Solved

bde / query / network performance

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Delphi XE2 application frozen on Windows 10 10 277
delphi exception 7 63
Find and Replace Stream with 0s 8 57
DBGrid or StringGrid ? 6 71
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

895 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now