-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 22/10/11 12:52, Bo Peng wrote: > I mean, is it possible, in theory, to read a sqlite database from > multiple threads/processes each with performance comparable to a > single thread/process?
Yes. The details are explained here: http://www.sqlite.org/lockingv3.html You'd also be far better off having fewer tables with a column corresponding to the table name in a master table. Also if you are doing counts like that then you could maintain a table of the counts using triggers to update it. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk6jJPMACgkQmOOfHg372QRFdwCgki4sfnummmja1WlB3aNiXPYI DNkAniiOkT2XUTNF62G/RXg1DD/aLSle =BmWY -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users