Daniel Franke wrote:
Hi everyone,
is there a way to employ more than one process (or processors) in a single
update statement?
No. SQLite is I/O bound so it won't help even if you could.
I'm creating a table by inserting rows from a select statement. Given enough
memory this takes a few hours for small datasets and ages for larger ones.
When I do a CREATE TABLE ... AS SELECT on my 3-year-old desktop, I get a table
created at over 29000 rows/second and about 3.35MB/sec. At that rate, 1 hour
of runtime should give you about 100 million rows and 12 GB. Not what I
would call a "small dataset".
Perhaps you could explain better what it is you are doing?
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
