The processing loop that is stalling our systems contains no SQL
or filters. Just a short series of inserts into large indexed tables.
Steven
On 21 Sep 99, at 20:33, Maurice Butler wrote:
> 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
>
Steven Wild
Director
Wild Software Ltd
P O Box 33-216
Christchurch, NZ
Ph & Fax 64 3 377-0495
_______________________
Chreos Business Systems
_______________________
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
