SQLite Forum

I am using SELECT to search a value 

SELECT * FROM test WHERE available = '1' LIMIT 1

--

LIMIT seems to still do the work and then discard the extra results
but I only need the first record and want to stop SQLITE after that
to save resources