SQLite Forum

get only first record found
You have the best SELECT command.  However, you may not have the best schema to keep time and processing to a minimum.  Do this …

<code>    CREATE INDEX test_available ON test (available)</code>

… just once.  Then try the SELECT command again.

PS: I see that this is just a test, but other people may find this code, so I remind them it is considered bad style to use 'SELECT *' in real production code.  You should name the columns you want.