Solved

bde / query / network performance

Posted on 1998-08-21
3
182 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
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…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
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 …

860 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