SQLite Forum

Deferred index update?
Login
I can't (this would produce wrong data when not in create-from-scratch mode). But even if I could, it would still result in long runtime because the index would still need to be updated continuously.

I've found [an old StackOverflow thread][1] about a very similar usecase.  I'm inclined to try the approach suggested there (dropping and recreating an index). I'll need some generic code to remove the potential duplicates. But maybe there's an easier way?

 [1]: https://stackoverflow.com/questions/8963826/is-there-a-way-to-postpone-updating-an-index