I'll try to do whatever I can.
On Tue, Jun 12, 2018, 8:10 PM Simon Slavin wrote:
> On 12 Jun 2018, at 10:49am, Space Pixel wrote:
>
> > the console
> > shows a warning, about an inappropriate loader to some C# file.
>
> There is no C# code in SQLite. It's all plain C. Can you show us the
> er
On 12 Jun 2018, at 10:49am, Space Pixel wrote:
> the console
> shows a warning, about an inappropriate loader to some C# file.
There is no C# code in SQLite. It's all plain C. Can you show us the error
message and tell us how it relates to you using SQLite commands ?
Simon.
_
ne, 2018 17:50
> >To: SQLite mailing list
> >Subject: Re: [sqlite] Trigger Performance
> >
> >Trying again/
> >Specifically, preparation of the constant "trigger part" of the
> >statement is
> >the overhead? Correct?
> >
> >On Tue, Ju
sers-
>boun...@mailinglists.sqlite.org] On Behalf Of David Burgess
>Sent: Monday, 11 June, 2018 17:50
>To: SQLite mailing list
>Subject: Re: [sqlite] Trigger Performance
>
>Trying again/
>Specifically, preparation of the constant "trigger part" of the
>statement is
&g
served difference.
>>
>> ---
>> The fact that there's a Highway to Hell but only a Stairway to Heaven says a
>> lot about anticipated traffic volume.
>>
>>
>>>-Original Message-----
>>>From: sqlite-users [mailto:sqlite-users-
>>>boun...@mailing
mailinglists.sqlite.org] On Behalf Of David Burgess
>>Sent: Monday, 11 June, 2018 00:40
>>To: SQLite mailing list
>>Subject: Re: [sqlite] Trigger Performance
>>
>>> The trigger is adding a mere 10% overhead on a million rows ...
>>3.24 on a real data DB (16 colum
I have a table where I insert 284,000 rows
time taken 3.39 seconds.
I add the following trigger
CREATE TRIGGER x_trigger BEFORE INSERT ON x
WHEN
0 = 1
BEGIN SELECT RAISE ( ABORT, 'raise' );
END;
time taken 4.49 seconds.
___
sqlite-
sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of David Burgess
>Sent: Monday, 11 June, 2018 00:40
>To: SQLite mailing list
>Subject: Re: [sqlite] Trigger Performance
>
>> The trigger is adding a mere 10% overhead on a million rows ...
>3.24 on a real da
> 0.0491803278688524
> Run Time: real 0.000 user 0.00 sys 0.00
> sqlite> .exit
>
>
> What version of SQLite are you using?
>
> ---
> The fact that there's a Highway to Hell but only a Stairway to Heaven says a
> lot about anticipated traffic volume.
>
Lite are you using?
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of David Burgess
>Sent: Su
I have a table where I drop, create and insert 284,000 rows
time taken 3.39 seconds.
I add the following trigger
CREATE TRIGGER x_trigger BEFORE INSERT ON x
WHEN
0 = 1
BEGIN SELECT RAISE ( ABORT, 'raise' );
END;
time taken 4.49 seconds.
__
11 matches
Mail list logo