Hello! On Saturday 21 March 2009 17:31:45 P Kishor wrote: > My intent is to simply retrieve a BLOB and > deserialize it... it would possibly be quicker than 33 ms per > retrieval. Well, I haven't yet completed this test because each BLOB > is taking about 430 KB. At 1 million rows, that is going to occupy > upward of 400 GB. 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.
zlib compression may help you. Best regards.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users