Hello Greg, I found this to be the case too. The difference between 1K and 8K is staggering. I default all my windows DB's to 8K now.
Tuesday, February 22, 2011, 1:59:29 PM, you wrote: GB> I'm currently dealing with a similar issue. I've found that the page_size GB> PRAGMA setting can have a dramatic effect on how long it takes to "warm up" GB> the table. On Windows 7, with page_size=1024, a SELECT COUNT(last_column) GB> takes 40.2 seconds. page_size=4096 takes 15.5 seconds. page_size=8192 takes GB> 8.5 seconds. This was done with a reboot between each test. -- Best regards, Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users