On Tue, 27 Jul 2004, Daniel Franke wrote:
>
>Hi everyone,
>
>is there a way to employ more than one process (or processors) in a single
>update statement?
>
>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.
>There's a SMP-system next door, 64 cpu's, 64gb of ram - any chance I can use
>them to get my results before retirement? :)
Are you doing the select into a dataset, then cycling through the dataset
in your program with an INSERT per row?
If so, then try inserting within a single transaction:
BEGIN TRANSACTION;
INSERT ...
INSERT ...
...
INSERT ...
COMMIT TRANSACTION;
This should significantly improve insert performance, as it sounds like
you're currently not using a single transaction.
Oh, and in answer to your origional question, no, SQLite supports only a
single writer to the database for data integrity reasons.
>
>Thanks in advance
> Daniel
>
Christian
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
