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?
>From: Aaron Scott-Boddendijk <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
>Subject: Re: [DUG]: DBF updating slow
>Date: Mon, 9 Aug 1999 14:41:49 +1200
>
> > While appending bulk records to a dbf file we have found that the
>process
> > slows to a crawl after about 1000 records. Closing and re-opening the
> > tables does not help. Shutting down the application and restarting does
> > help. We have tried dbiSaveChanges also di nothing to speed it up.
>
>You're not posting twice are ya ;)
>
>on a more serious note
>Does the delay seem to be increasing drive activity? if it's not then it's
>not the
>search logic for record insertion and I'd return to checking your insertion
>code
>to make sure that there's not a memory leak - say something like creating a
>new database connection each time without closing the last or perhaps
>object
>construction each iteration that could be cached for the whole process...
>LIkely to
>need an example snippet to get any furthur down the guesstimate track.
>
>1. Open Exclusively if at all possible.
>2. Ensure that no live datacontrols are connected to your exclusive
>dataset.
>3. don't dbiSaveChanges every iteration since the table is exclusive no-one
>else
> can mess with it anyway.
>
>--
>Aaron Scott-Boddendijk
>Jump Productions
>(07) 838-3371 Voice
>(07) 838-3372 Fax
>
>
>---------------------------------------------------------------------------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz