vendredi 2 janvier 2015

Stop at first match in a sqlite query

I have a sqlite3 database worth 4GB and 400k rows. The id column is a consecutive number starting at 1. If I query the following



select * from game where id = 1


After printing the first match the query continues until it reach the 400k row, thus taking a few seconds to finish the query.


How do I make the query stop at the first match?


Or how do I go directly to specific row since id and rowcount are the same?


Aucun commentaire:

Enregistrer un commentaire