Re: [pysqlite] :memory: db

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Dinesh B Vadhia wrote:
> We want to store >5m rows in a :memory: sqlite db for read-only access. 
> Will we see a significant performance uptick against a disk-based sqlite
> db?  Could you provide pointers or links to optimizing :memory: db's for
> read-only access.  Thank-you!

Why don't you try it with your data and your queries?  Also see
http://www.sqlite.org/pragma.html which lets you alter the default
SQLite cache sizes.

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkqgaXwACgkQmOOfHg372QRcdQCgnSW16piQWw3wzVemmQZiPyun
XDoAoKKFgLekSXg9Hm072h9zEqEH2JNt
=nBQX
-----END PGP SIGNATURE-----