delays
>the rest of transaction ; Some foreign key violations don't trigger
>the error at all
>
>On 8/2/18 3:46 PM, Keith Medcalf wrote:
>> You are required to have a UNIQUE index on the PARENT KEYS in a
>foreign key relationship.
>>
>> Depending on whether the PAR
Hello Yuri,
Friday, August 03, 2018, 12:06:14 AM, Yuri wrote:
> On 8/2/18 3:46 PM, Keith Medcalf wrote:
>> You are required to have a UNIQUE index on the PARENT KEYS in a foreign key
>> relationship.
>>
>> Depending on whether the PARENT:CHILD is 1:1 or 1:N you need either
>> a UNIQUE (1:1) or r
On 8/2/18 3:46 PM, Keith Medcalf wrote:
You are required to have a UNIQUE index on the PARENT KEYS in a foreign key
relationship.
Depending on whether the PARENT:CHILD is 1:1 or 1:N you need either a UNIQUE
(1:1) or regular index on the child key.
Why is index on PARENT KEY in a foreign key
#x27;s a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: Yuri [mailto:y...@rawbw.com]
>Sent: Thursday, 2 August, 2018 16:37
>To: SQLite mailing list; Keith Medcalf
>Subject: Re: [sqlite] Violated failed fore
On 8/2/18 3:17 PM, Keith Medcalf wrote:
.lint fkey-indexes
and it will tell you what indexes you forgot to create that cause the issue you
are seeing.
But this problem isn't about a missing index.
Yuri
___
sqlite-users mailing list
sqlite-users
sers-
>boun...@mailinglists.sqlite.org] On Behalf Of Yuri
>Sent: Thursday, 2 August, 2018 16:05
>To: sqlite-users@mailinglists.sqlite.org
>Subject: Re: [sqlite] Violated failed foreign key constraint delays
>the rest of transaction ; Some foreign key violations don't trigger
>the error at all
&
On 8/2/18 7:02 AM, David Raymond wrote:
So for your test script there, try inserting a record with the violation ID a
little bit later and see if it suddenly speeds up again. In my Python version
of your script it does indeed speed back up again once the outstanding
violation is fixed.
The
t: Thursday, August 02, 2018 4:59 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Violated failed foreign key constraint delays the rest of
transaction ; Some foreign key violations don't trigger the error at all
On Thu, Aug 2, 2018 at 10:34 AM Keith Medcalf wrote:
>
On Thu, Aug 2, 2018 at 10:34 AM Keith Medcalf wrote:
>
> Yes. Look at the CREATE TABLE for table A (completely ignore table B as
> it serves no purpose whatsoever)
>
Rah, silly me... I assumed A.aid referenced B.id. Why have a B table at all
then.
> Also, if you create an index on the chi
ers [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Dominique Devienne
>Sent: Thursday, 2 August, 2018 01:48
>To: General Discussion of SQLite Database
>Subject: Re: [sqlite] Violated failed foreign key constraint delays
>the rest of transaction ; Some foreign
sqlite.org] On Behalf Of Dominique Devienne
>Sent: Thursday, 2 August, 2018 01:48
>To: General Discussion of SQLite Database
>Subject: Re: [sqlite] Violated failed foreign key constraint delays
>the rest of transaction ; Some foreign key violations don't trigger
>the error at
On Thu, Aug 2, 2018 at 9:35 AM Keith Medcalf wrote:
> You observe no violation when VIOLATION is 0 because there is no
> referential integrity violation to report ...
>
Really Keith? Parent IDs are in range [0, NROWS)
Child/FK IDs inserted are in range [NROWS, 2*NROWS)
How's that not an FK viol
On Thu, Aug 2, 2018 at 12:57 AM Yuri wrote:
> The attached testcase injects the foreign key violation into a long
> transaction. This makes the remainder of the transaction much slower,
> even though the foreign key is deferred, and should only be checked in
> the end of the transaction.
>
Right
int delays the
>rest of transaction ; Some foreign key violations don't trigger the
>error at all
>
>The attached testcase injects the foreign key violation into a long
>transaction. This makes the remainder of the transaction much slower,
>even though the foreign key is deferred,
The attached testcase injects the foreign key violation into a long
transaction. This makes the remainder of the transaction much slower,
even though the foreign key is deferred, and should only be checked in
the end of the transaction.
While working on this testcase, I found that sometimes t
15 matches
Mail list logo