Bo Peng <ben....@gmail.com> wrote: > I have a database with about 5000 tables each with more than 1 million > records. I needed to get some summary statistics of each table but > find that it will take days to run 'SELECT count(*) FROM table_XX' > (XX=1,...,5000) sequentially. I therefore created 10 threads, each > having its own database connection (sqlite3.connect() from python). To > my dismay, it appears that only one thread was allowed to access the > database at any time so the overall speed was not improved.
You may create multiple threads, but your hard drive only has one set of heads. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users