[odb-users] SQLIte "INSERT" slows dramatically...

Boris Kolpackov boris at codesynthesis.com
Wed Sep 16 11:13:19 EDT 2015


Hi Andrew,

Andrew Cunningham <andrew at a-cunningham.com> writes:

> The key point I want to make here is that although this foreign key
> constraint was violated for only a handful of "elements" the performance of
> SQLite was degraded 1000x from that point on.

Yes, that's indeed quite interesting, thanks for sharing! I found that
SQLite has such "dark corners" here and there.

I would suggest that you re-send your findings to the SQLite mailing
list and see what the developers say. They are usually very helpful.

Boris



More information about the odb-users mailing list