Program slowing as sqlite database grows

Question

My program seems to be slowing down on delete commands as my sqlite database grows. Is there anything I can do to help performance?

Roei Bar · Answer

well my friend 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

patrick · Answer

Hey you were right on I added a single index and it made all the difference in the world.

patrick · Answer

Its odd the program doesnt seem to slow unless the database is accessed on a network drive. Does this indicate there are problems outside the program?

patrick · Answer

Okay so instead of deleting and not paying attention to whether or not the record exists first I should be checking that the record exists then deleting?

Roei Bar · Answer

well faulty index usually means you are trying to access an index in the array that is does not exist :-)

patrick · Answer

Faulty index - can you elaborate on this?