I am trying to get a chunk of rows from a table which has 16 million rows. The table is indexed. I am passing the query as "SELECT * FROM persons WHERE hid = 5;" and it takes a few minutes to get me the results. Can anyone suggest how to make it faster?
Gaurav _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
