Have you been able to investigate this yet? Any ideas or recommendations? I sent you the analyzer output to [EMAIL PROTECTED] as it was too large to post on here.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 October 2005 14:58 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Very Slow delete times on larger databases, please help! "Allan, Mark" <[EMAIL PROTECTED]> wrote: > We are experiencing incredibly slow delete times when deleting a > large number of rows:- > > We are using SQLite on an embdedded platform with an ARM7 processor, > 2Mb RAM and 32Mb NOR Flash memory 25Mb of which is allocated for > storage for our database. > What operating system? Can you send the output of sqlite3_analyzer run against your database file prior to doing the delete? Have you tried upgrading to a later version of SQLite? -- D. Richard Hipp <[EMAIL PROTECTED]> 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.