Simply make some tests? The experiment is the only measure for the truth.
Personally I am using SQLite for my project AsmBB (web forum software in assembly language). The project widely uses FK in order to provide DB consistency. It was tested during several "slashdot effect" kind of events and demonstrated very high performance. So, in my experience using foreign keys does not degrade the performance noticeably. Regards. On Mon, 24 Apr 2017 14:31:32 +0200 Bubu Bubu <sivada...@gmail.com> wrote: > Hi everyone, > > Foreign keys have been implemented in sqlite since 3.6.19. My boss has > always been reluctant to use this mechanism in our development under the > pretext of performance loss. He told me he read that somewhere once, but he > can't recall precisely the reasons that lead him think that. > > I've read 3.6.19 release note and try to find info that cover that issue > without finding any. > > Can someone tell me if there can really be performance issues when one uses > foreign keys in their database? > > Thanks a lot > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- http://fresh.flatassembler.net http://asm32.info John Found <johnfo...@asm32.info> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
