Solved

bde / query / network performance

Posted on 1998-08-21
3
183 Views
Last Modified: 2010-04-04
I am working with delphi 1, and i heve made a application which uses
paradox tables on a server. When i launch a query the network has a load
off more then 90% . When more users do this , then the normal
updatscreen gives an error and the result is damaged indexes.
do you know a solution??

thanks a lot,

Lambert Venema , Holland.
0
Comment
Question by:lambertvenema
3 Comments
 
LVL 1

Expert Comment

by:EmmDieh
ID: 1337436
This seems to be typical for a file based database.
They only support a handful of users and paradox seems
to suffer from frequent index corruptions.

I would use a client-/server database like InterBase.

0
 
LVL 5

Expert Comment

by:mayhew
ID: 1337437
Also, are you using TTable or TQuery components?

TTable's can really increase overhead.

Don
0
 
LVL 1

Accepted Solution

by:
jcasteel earned 100 total points
ID: 1337438
File base database systems are not the best way to do it.

There are a few items that will increase the load on your network.

1. Use TQuery instead of TTable.
2. Prepare your statements before executing them.
   if you do not prepare the TQuery object, Delphi itself will prepare it each time when it is executed.
3. If you have a few of lookup table with towns that have a limited number of items -> read them in memory with linked lists so you can access them without going to the database each time.
4. Try to group transactions instead of commiting each little transaction.  TDatabase object - > StartTransaction and Commit;
 this means that a user will make several transactions ( inserts / updates / deletes ) before commiting the data.

I am not user if the following was already applicable in Delphi 1 maybe it is from Delphi 2
5. Put RequistLive false and use TUpdateSQL to make your changes

6. Try to limit the number of data  that is being retrieved by the user. If a table contains 100000 records, use TQuery with a where clause so only the relevant records are being retrieved.
Nobody is interested in 100000 records.

Thas what I did for my tuning of the application,

Have fun

Jan Casteels
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question