I have a huge sqlite database with 800,000 rows and it takes a long time if the row is near the end like select * from tbl where id=578511
. This is because the query runs from the beginning of the database, but is it possible to go just directly to that row as the id equals the rowcount.
Aucun commentaire:
Enregistrer un commentaire