 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Erdal Durdu
Guest
|
 Posted: Tue May 25, 2004 2:11 pm Post subject: Query Performance |
 |
|
Hello,
I have an Delphi application that uses paradox tables by Bde. The query
speed is pretty good when using local tables. But when I use database on a
networked station the query is very slow. Local data query time is about 1-2
seconds, and the same query for data on other station query is about 50
seconds. There is no multiple access.
I have an paradox for dos application with the same database and query
speed for both local and networked enviroment is approximately same.
Is these performance gap normal or there is something wrong?
Best kinds.
|
|
| Back to top |
|
 |
Bill Todd (TeamB)
Guest
|
| Posted: Tue May 25, 2004 3:08 pm Post subject: Re: Query Performance |
|
|
On Tue, 25 May 2004 17:11:37 +0300, "Erdal Durdu"
<erdaldurdu (AT) hotmail (DOT) com> wrote:
| Quote: | Is these performance gap normal or there is something wrong?
|
Normal in some cases. Paradox for DOS, particularly 4.0 and 4.5, made
much better use of indexes to improver query performance and reduce
network traffic than the BDE. IMHO you should use a database server
for any multiuser application.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
| Back to top |
|
|
Erdal Durdu
Guest
|
| Posted: Tue May 25, 2004 3:57 pm Post subject: Re: Query Performance |
|
|
Is there any tweak (I mean use something different than TQuery, or something
else ) to speed up queries?. I think, opening a table and locating a record
is not so slowly with bde. What are the parameters to consider?
By the way, what does IMHO mean?
"Bill Todd (TeamB)" <no (AT) no (DOT) com>, haber iletisinde sunlari
yazdi:v8o6b058ttllgvaqno263r7nu7ksefr531 (AT) 4ax (DOT) com...
| Quote: | On Tue, 25 May 2004 17:11:37 +0300, "Erdal Durdu"
[email]erdaldurdu (AT) hotmail (DOT) com[/email]> wrote:
Is these performance gap normal or there is something wrong?
Normal in some cases. Paradox for DOS, particularly 4.0 and 4.5, made
much better use of indexes to improver query performance and reduce
network traffic than the BDE. IMHO you should use a database server
for any multiuser application.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
|
| Back to top |
|
|
Bill Todd (TeamB)
Guest
|
| Posted: Tue May 25, 2004 4:36 pm Post subject: Re: Query Performance |
|
|
On Tue, 25 May 2004 18:57:23 +0300, "Erdal Durdu"
<erdaldurdu (AT) hotmail (DOT) com> wrote:
| Quote: | Is there any tweak (I mean use something different than TQuery, or something
else ) to speed up queries?. I think, opening a table and locating a record
is not so slowly with bde. What are the parameters to consider?
|
If you want speed use SetRange on a TTable instead of a TQuery.
SetRange always uses indexes.
| Quote: |
By the way, what does IMHO mean?
|
In my humble opinion.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
