Program slowing as sqlite database grows
My program seems to be slowing down on delete commands as my sqlite database grows. Is there anything I can do to help performance?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Roei BarPosted Sep 28, 2009, 4:22 PM
there are many things todo regarding application slowdown
main issue is large DB and faulty index, meaning that on each delete action you have todo a table scan for delete or manipulate the table records.
it is also vital to pay attention to the deleted records amount
i mean if you are doing a heavy delete during the db processing hours it will make it hard for him since it needs after every delete command to reindex the records
patrickPosted Oct 8, 2009, 4:46 PM
patrickPosted Oct 5, 2009, 3:12 PM
patrickPosted Oct 1, 2009, 10:08 AM
Roei BarPosted Sep 28, 2009, 5:45 PM
patrickPosted Sep 28, 2009, 5:23 PM