On 5/10/06, Allan, Mark <[EMAIL PROTECTED]> wrote:
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.
Is it possible to use a profiler tool on your embedded system?
One technique I've seen for debugging systems like that is to make a null modem
cable (either serial or parallel) and hook the embedded system to a terminal
or another computer. You can then put write statements into your code to
write debugging info to the port for collection and analysis. It's pretty
simple if you don't have any better tools. You can at least see what part
of the code is taking so long to execute.
