Try this:

BEGIN TRANSACTION
INSERT INTO...
...
INSERT INTO...
COMMIT TRANSACTION

Regards,
Ondrej

-----Original Message-----
From: Buu Hao Tran [mailto:[EMAIL PROTECTED] 
Sent: Saturday, August 21, 2004 1:06 PM
To: [EMAIL PROTECTED]
Subject: [sqlite] Very slow insert???

Hi all,
We have to insert ~ 8000 rows. It takes several minutes in P4 machine!!!
Pls help

Reply via email to