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? >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
