-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07/13/2011 03:06 PM, Samuel Neff wrote: > The BerkleyDB backed version of SQLite from Oracle supports page level > locking. Apparently this is where the real performance gains come from, not > swapping out the back-end.
That only helps with concurrency and makes things more complicated since you have to worry about page locks everywhere rather than a single whole file lock. SQLite's philosophy is to make each transaction execute as quickly as possible, rather than handle concurrent transactions with increased complexity (note that "Lite" in the name :-) See the very last bullet point of this page: http://www.sqlite.org/whentouse.html Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk4eHdIACgkQmOOfHg372QTQNwCbB8WoEWnS+zHKWCY7Dj8Tiwft Rv0AoKyZeJkhiZaPvQbpNqsqg+MbFYlw =zsd2 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
