Re: [sqlite] massive insert

[Cory Nelson]

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 this operation?.

In other case...

How i can insert multiples rows in one INSERT statment??

Thanks.



CiberCorreos(r)
Acercando las Nuevas Tecnologías a la población.
http://www.ciudadano.cu/


-
To unsubscribe, send email to [EMAIL PROTECTED]
-





--
Cory Nelson
http://www.int64.org

Re: [sqlite] massive insert

[Cesar David Rodas Maldonado]

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