lundi 24 août 2015

Insert into SQLite taking a lot of time

I have 2 copies of a SQLite Database. Database 1 has arrived at a state through some failed(Process killed through Task Manager) transactions. Database 2 has not had any failed transactions. Insert query on Database 1 takes about 200ms while the same query on Database 2 takes 0.5ms. The two databases have the same indexes. What are the other factors which could cause a delay in running INSERT query?

Aucun commentaire:

Enregistrer un commentaire