-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07/17/2010 09:51 PM, Peng Yu wrote: > I import a tab-sep file and create index on it. It seems that sqlite3 > only use 1 CPU. Is there a way to make it use more than one CPUs?
What kind of speeds are you seeing, and what do you think you would see if there was multi-CPU usage? There may be lots of scope for improving what you see for just one cpu. SQLite does not have builtin mechanism to automatically spread work over multiple cpus, nor would doing so result in any speedup as the data structures are locked by a database level mutex while in use. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkxClTYACgkQmOOfHg372QSBywCg1bm5UyCr7VtERj0RObqevaPv 5e4AoKc3JfAb7iPuYGIAtzNa4w3KdZgw =18t3 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
