Hi All,
Description of my setup:
My database contains
1) One table
2) 20 fields (contains date field to store the inserted time)
3) 100,000 records
4) database size is 21MB.
5) No INDEX created.
6) Sqlite version 3.5.9.
The retrieval logic is such that to retrieve the oldest 10 records along
with some additional constraints (say a, b and c are columns and the
constraints are like a=1 AND b < c).
So my WHERE clause is like "CurrTime <= ExpireTime AND CurrTime >=
NextProcessingTime AND a=1 AND b < c"
And my ORDER BY clause is " CurrTime - NextProcessingTime DESC, b ASC"
LIMIT 10.
The problem is that it is taking around 6-7 seconds to retrieve 10
records from the table containing 100,000 records.
One more problem is that the UPDATE query is getting failed with error
[Databse is locked] during this retrieval. Of course, I guess any other
query also would have failed during this period.
So, please let me know, is there any tuning that can help my retrieval
to get better.
I was expecting that Sqlite shall give better performance for at least
10 million records. If I am correct, please help me out to achieve the
same or if not please let me know how best we can achieve using Sqlite.
Thanks in advance for your help.
Thanks and Regards,
Vinod N.M.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
