On 13 Jan 2012, at 7:57pm, Normand Mongeau wrote: > begin immediate transaction > insert 1 record in tableA > insert 1 record in tableB > insert 1 record in tableC > commit transaction > > Inserting 534 records takes about 75 seconds. Most of the time (about 71 > seconds) is spent on the commit transaction instruction.
Can you put one transaction around the whole lot rather than 178 separate transactions ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
