Peter Jones wrote:
> The code is in a server app so there is no user interface
> components getting involved. It's a simple loop of read from one
> table, do some checks on the main database and append/edit
> another table. The output table can't be used exclusively as
> it's already in use by another app.
>
> Got any more ideas?
Drop index beforehand, re-establish after? Or is it non-indexed?
cheers,
peter
============================================
Peter Hyde, SPIS Ltd, Christchurch, New Zealand
* Print-to-Web automation http://TurboPress.com
* Web design, automation and hosting specialists
* TurboNote: http://TurboPress.com/tbnote.htm
-- small, FREE and very handy
Find all the above and MORE at http://www.spis.co.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz