CODEWITHSUNDEEP
sqliteindexingsql-drop
Santosh Tiwari
Santosh Tiwari

Reputation: 1216

How can I speed up index deletion?

My SQLite database of about 75 GB takes almost 4 hours to create an index. After indexing, file size is about 100 GB. When I have to insert/delete/update a few GB of data I am deleting the index before modifying and after that the indexes are recreated. Dropping the index takes a huge amount of time (of the same order as creating the index).

When all data needs to be regenerated I write to a new database file and replace the original one to avoid having to drop indices. How can I speed up index deletion?

Upvotes: 7

Views: 1010

Answers (0)

Related Questions