Re: TZF - DeleteRec
"b.evers" <[email protected]> Tue, 8 Jul 2003 22:09:29 +0200
| Newsgroups | gmane.comp.lang.delphi.topaz |
|---|---|
| Message-ID | <[email protected]> |
Hi, ----- Original Message ----- From: <[email protected]> To: <[email protected]> Sent: Tuesday, July 08, 2003 7:31 PM Subject: RE: TZF - DeleteRec > Thanks again. > > But I am looking for a way not to traverse all the records one by one to > delete, I indexed my Database to make my delete operation faster. For now I > am doing something similar your example, but I do not like it. I log some > data every 1/10 of a second so the database is huge and deleting records by > traversing every record will make my application slow. > Probably the indexes make your application slow also. They need to be updated on every insert, update and delete. How many indexes do you have on your database? And does this run on a standalone machine or on a network drive? Did you consider logging in bloks and putting them in a memo? When you delete, do you delete 1 sample, or complete blocks? When you delete complete blocks, you could consider making more dbase files, i.e. 1 for every hour? Benno ==^================================================================ This email was sent to: [email protected] EASY UNSUBSCRIBE click here: http://topica.com/u/?clvXPN.a5kvff.Z2NsZHQt Or send an email to: [email protected] TOPICA - Start your own email discussion group. FREE! http://www.topica.com/partner/tag02/create/index2.html ==^================================================================