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

[Boris Kolpackov]

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