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