Re: [sqlite] Performances and Foreign keys

n key checker, 10% the size, quicker lookups etc. > > > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of John Found > Sent: Monday, April 24, 2017 12:24 PM > To: sqlite-users@mailinglists.sqlite.org > Subject: Re: [sqlite] Perf

Re: [sqlite] Performances and Foreign keys

Ok, I'll test with and without FKs. As you said, since one can turn them on and off, maybe there is something to do there. Thanks for your answer 2017-04-24 14:52 GMT+02:00 Dominique Devienne : > On Mon, Apr 24, 2017 at 2:31 PM, Bubu Bubu wrote: > > >

Re: [sqlite] Performances and Foreign keys

, quicker lookups etc. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of John Found Sent: Monday, April 24, 2017 12:24 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Performances and Foreign keys Simply make some

Re: [sqlite] Performances and Foreign keys

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

Re: [sqlite] Performances and Foreign keys

On 24 Apr 2017, at 3:20pm, Clemens Ladisch wrote: > Bubu Bubu wrote: >> Can someone tell me if there can really be performance issues when one uses >> foreign keys in their database? > > The documentation > warns against a

Re: [sqlite] Performances and Foreign keys

Bubu Bubu wrote: > Can someone tell me if there can really be performance issues when one uses > foreign keys in their database? The documentation warns against a case where some operations can be slow if you do not have an index on the child

Re: [sqlite] Performances and Foreign keys

On 2017/04/24 2:31 PM, Bubu Bubu 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

Re: [sqlite] Performances and Foreign keys

On Mon, Apr 24, 2017 at 2:31 PM, Bubu Bubu wrote: > 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

[sqlite] Performances and Foreign keys

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.