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 );