Have you tried increase sqlite cache size and page size? pragma cache_size; pragma page_size;
Try making page_size=4096 Then make cache_size*page_size as big as your database file. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, April 16, 2013 1:10 PM To: [email protected] Subject: Re: [sqlite] Help speed up query I tried transfering the database to an in memory copy and running the queries. It is actually a little slower but not much. I'm sure there are tables that are not being accessed and so loading them into memory would add to the time. Vance on Apr 16, 2013, [email protected] wrote: > >Yes, the DBs are on my local disk. The quoted times are after the first run so mostly >in cache. It takes about twice the time the first run for both SQLite and MS Access. > >Vance > >on Apr 16, 2013, Simon Slavin <[email protected]> wrote: >> >> >>On 16 Apr 2013, at 2:32pm, [email protected] wrote: >> >>> It was about 380 ms. Now it is taking about 610 ms. >> >>Can I check with you that the database file is stored on a disk of the computer which >>is executing the SQLite commands ? In other words, that this is a local hard disk >>and not one shared over a network. >> >>Simon. >>_______________________________________________ >>sqlite-users mailing list >>[email protected] >>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >_______________________________________________ >sqlite-users mailing list >[email protected] >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
