SQLite Forum

SQLite .NET: CommandBuilder performs really bad on tables with a lot of indexes
Login
Incidentally, what happens if you clone the DB, drop all the data, leaving the schema intact, tables empty? Is it still slow?

What if you drop half the indices?

What if you drop the *other* half? Can you bisect your way towards a performant subset of indices, or is it simply that the opening speed drops as a direct function of the number of indices?