-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Brian Dantes wrote: > Can anyone offer any explanations for these huge disparities in sqlite > performance on these two platforms?
Run the SQLite analyser (available from the download page) on the resulting databases and see what it says is different. An example of something that could lead to disparities is if the database is using different encodings. An ASCII string in a UTF16 encoded database will take up twice as much space as a UTF8 encoded database (which means twice the I/O) plus the indexed strings being twice the size (another doubling of I/O) plus the cache available for other information will be reduced. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkphf90ACgkQmOOfHg372QRHWACbBJjTvvCDk2Xqqufu7r7HvO3n lw0Anjh0UxhczDmgfaGalIwuCOiO++kP =FlEd -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
