Hello! On Sunday 01 November 2009 21:14:05 Scott Hess wrote: > Your results for the contents table pretty much match what I recall. > For that table, compression is helpful without much downside. I seem > to recall that zlib's costs are mostly on the compression side, so for > databases with relatively low update rates, it might be reasonable to > amp up the compression ratio. Gains can really depend on the amount > of data you are working with relative to the size of your page cache
The zlib compression for hight update rates is good because may really decrease the disk activity. The processors now have more better performance than disks. Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
