0

I have 10000 records in a table in my SQLite db. When I try to delete some of it's records I get that the result that it has deleted the records in milliseconds which nearly about 500ms. But in reality the background process continues for nearly 8 seconds. I tried using transaction, cache size, but I do not get it to work to get a better performance. What am I missing?

Piyush Kulkarni
  • 1
  • 3
  • 1
    Can you share the code in question? – Serg Apr 20 '21 at 09:53
  • May be this can help : [sqlite delete slow](https://stackoverflow.com/questions/21707190/sqlite-delete-incredibly-slow-how-to-speed-up) – Ptit Xav Apr 20 '21 at 10:09
  • Background process? Sqlite does everything in the process executing the query, not a server like most databases. – Shawn Apr 20 '21 at 16:58

0 Answers0