Hi,
I have an app using sqlite, and the main insertion point is very slow on
commitTransaction.
This is what I do:
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.
If it's any important, this is all using the C++ API, with prepared
statements.
Table A has 14 columns, with 2 indexes (not unique) and 1 primary key
Table B has 9 columns, with 2 non-unique indexes and 1 primary key
Table C has 13 columns, 1 non-unique index and 1 primary key
Current record count is 12, 10 and 627. Reason for few records in tableA
and tableB is that I insert duplicate primary keys and just ignore
SQLITE_CONSTRAINT errors.
Any ideas on what could be causing this?
Thanks,
Normand
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
