sqlite first executed query slow after opening connection sqlite first executed query slow after opening connection sqlite sqlite

sqlite first executed query slow after opening connection


Most likely after the first time you run this, you've loaded cache up with all your data, so subsequent queries are fast. Do you have an index on entry? An index will allow efficient querying using entry as a filter. You may want to create one:

CREATE INDEX i_tableone_entry ON tableOne( entry );