On Sat, Mar 21, 2009 at 10:28 AM, Kees Nuyt <k.n...@zonnet.nl> wrote: > > Hi Puneet, > > On Sat, 21 Mar 2009 09:31:45 -0500, P Kishor > <punk.k...@gmail.com> wrote: > >>Part 1. >>------- >> >>I have the following schema in a SQLite db that is 430 MB on my >>Macbook laptop's 320 GB HFS+ formatted 7200 RPM disk with an 8 MB >>cache. > > [...] > >>How can I, if at all, speed this up? > > What is your page_size? > Does it match your platforms optimum I/O size? > Is the database connection kept open, so the cache remains > valid?
I should have mentioned the page_size in my OP. It is 32768 set by me at the start of db creation. Yes, the db connection is kept open. > >>Part 2. >>------- > > [...] >> Well, I haven't yet completed this test because >>each BLOB is taking about 430 KB. > > [...] > >> I broke the load_blob_table routine after about a >>third of the records had been processed because I found even the >>loading_the_blobs to be excruciatingly slow. >> >>Suggestions? > > Especially BLOBs will benefit from a large page_size, I > think. For this schema and estimated BLOB size I would start > with the maximum page_size allowed, that is 32768 bytes. > -- > ( Kees Nuyt > ) > c[_] > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Carbon Model http://carbonmodel.org/ Open Source Geospatial Foundation http://www.osgeo.org/ Sent from: Madison WI United States. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
