Re: [sqlite] massive insert

surround them in a transaction. BEGIN INSERT... INSERT... COMMIT On 11/2/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I have a table where i insert data massively near 10,000 or 20,000 rows and that take to much time, near 1h for each 10,000 rows. How i can increase the performance for

Re: [sqlite] massive insert

My friend.. very simple... use a transaction to do that... BEGIN; insert into ... insert into ... insert into ... insert into ... ... ... ... insert into ... COMMIT; I usually insert 1 in 5 seconds in a non good PC -- Cesar Rodas http://www.phpclasses.org/grank