On 18 Jul 2010, at 5:51am, 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? I > searched 'parallel' on sqlite.org. But I don't find anything.
This operation is not slowed down by your CPU speed. It is slowed down by the speed of your storage system -- probably hard disk. Even if you could split it between many CPUs they would all be waiting for the same hard disk. Just in case you didn't know, you should definitely be using a transaction while you import: BEGIN, then COMMIT. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
