Simon and everyone who has thrown ideas into the mix, I very much appreciate the effort that you folks have put into this! If nothing else, I am learning from this exorcise.
I set the page_size to 4096 and cache_size to 1024. (I picked the next binary size above the 2976 KB size of the DB under test.) No difference in speed. (I ran both in memory and off of disk versions). Vance on Apr 16, 2013, Michael Black <mdblac...@yahoo.com> wrote: > >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: sqlite-users-boun...@sqlite.org >[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of ven...@intouchmi.com >Sent: Tuesday, April 16, 2013 1:10 PM >To: sqlite-users@sqlite.org >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, ven...@intouchmi.com 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 <slav...@bigfraud.org> wrote: >>> >>> >>>On 16 Apr 2013, at 2:32pm, ven...@intouchmi.com 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 >>>sqlite-users@sqlite.org >>>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >>_______________________________________________ >>sqlite-users mailing list >>sqlite-users@sqlite.org >>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >_______________________________________________ >sqlite-users mailing list >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >_______________________________________________ >sqlite-users mailing list >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
