Jay, Yes there is a index on the date column. The delete operation is on date, specifically dates older than a date entered by the user (so he/she can clear out old records and keep newer ones). I don't think the time taken is slowed by the time SQLite takes to find the rows as I do a SELECT COUNT with the same query and this does not take as long as the DELETE. I don't know why it takes so long, I dont think it is the writing to the file as this should only happen on COMMIT and I can see in debug output that the COMMIT only takes a few seconds. It is before COMMIT that takes the time.
Mark > -----Original Message----- > From: Jay Sprenkle [mailto:[EMAIL PROTECTED] > Sent: 10 May 2006 14:10 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] accurate progress indication > > > On 5/10/06, Allan, Mark <[EMAIL PROTECTED]> wrote: > > > > On our target unit, it takes alot longer, deleting approx > 800 records from one table and 2400 from another table will > take approx 1min 30 secs. The bulk of this time is before the > COMMIT, therefore before the IO stage I believe, the COMMIT > only takes a few seconds. So in this case we would like a > progress indicator to represent a reasonably accurate > representation of progress so user will not think the unit > has locked up. > > > Do you have an index on your tables that allows Sqlite to find the > rows to delete quickly? > > DISCLAIMER: This information and any attachments contained in this email message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email, and delete the original message immediately.
