After struggling with performance issues of local programs accessing shared
tables on a local machine I have the key point is do not use SQL queries on
dbf or db tables. The reason for this is while the query runs it locks the
table and uses 100% of the processor resources to run the query. It is
faster and uses less processor resources to run the equivalent query by
using ttable components an loop through the data.
Also filters should be minimised as they impact the performance of the
ttable component.
Instead use indexes so the data you require is at the start of the table
and when you note that you have reached the end of the data you need to
process you then can exit your loop.
Thank you
Maurice Butler Like Magic Ltd
Systems Engineer P.O. Box 89
025 273 9248 Temuka
CAUTION:
The views expressed in this correspondence are the personal view of the
author and not necessarily the view of the company.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
