Hi all,
I have a query that, first time is executed, takes 40 seconds to give results.
After the first execution, it takes about 15 seconds.
My question is: Is the db loaded into memory? I thought db is read from hard
disk every time, isn't it?
Why this difference in performance?
Thanks,
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
