I see. Thanks nameless person known as sqlite-mail (npkasm for short), what you say makes sense. However it does not explain why the pragma checks are so slow.
Anyhow, npkasm, I will keep in mind for the future. Good point indeed. On Wed, Aug 19, 2015 at 3:59 PM, sqlite-mail <sqlite-mail at dev.dadbiz.es> wrote: > Hello ! > > The problem with foreign keys most of the time is not the the referenced > table/field (normally primary key that do no need extra index) but the > dependent table/field when they do not have a proper index, any time you > update/delete a record on the referenced table a linear scan is performed on > all dependent tables and that can be a lot time consuming depending on the > number of records on then. > > I've got this problem on a heavily foreign key constrained database and it > took me a bit to realize that ! > > Cheers ! >> @nameless person known as sqlite-mail, >> Yes, I do have foreign keys. But each relate to a primary key; there >> are no explicit indexes on this primary keys, but they should not be >> needed because primary keys are indexed automatically. >> Or are they? >> >> >> > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
