#sqlite3 #sqlite #database #software #development #programming #performance #servers #index #indexing #fail #explain !python
Can anyone explain why this happens? I didn't figure it out quickly. I think it's actually a fail. I'm using sqlite3 for many small local apps, yet it desn't mean that the database would be small. So I started to wonder some performance issues and this is what I found.
http://www.sami-lehtinen.net/blog/sqlite3-simple-index-tests-and-worrying-results