Okay, the difference is the "lots of inserts" -vs- the "one insert".
When I do the same thing (dump the contents of the table to a file and then
reload the dump), the overhead of the trigger is about 33% (same as you).
There is not only the time to "insert the data" but also the overhead of
pr
Hi,
I'm new in SQLite.
I try to insert email addresses into a table and get an error with addresses
they have a single quotation mark ( na'm...@domain.ltd ).
Sorry I'm facing this problem for weeks, I can't find a solution.
Is there a known workaround for it ?
Thanks for help
Peter
___
Sorry I forgot I‘m using C#
> Am 11.06.2018 um 10:07 schrieb Peter Nacken :
>
> Hi,
>
> I'm new in SQLite.
>
> I try to insert email addresses into a table and get an error with addresses
> they have a single quotation mark ( na'm...@domain.ltd ).
>
> Sorry I'm facing this problem for weeks
On 11 Jun 2018, at 9:07am, Peter Nacken wrote:
> I try to insert email addresses into a table and get an error with addresses
> they have a single quotation mark ( na'm...@domain.ltd ).
>
> Sorry I'm facing this problem for weeks, I can't find a solution.
Every single ' character in a strin
> Le 11 juin 2018 à 10:07, Peter Nacken a écrit :
>
> I try to insert email addresses into a table and get an error with addresses
> they have a single quotation mark ( na'm...@domain.ltd ).
> Sorry I forgot I‘m using C#
(Assuming: "create table T(E text);" for the following.)
If you're build
On 11 Jun 2018, at 09:07, Peter Nacken wrote:
> I try to insert email addresses into a table and get an error with addresses
> they have a single quotation mark ( na'm...@domain.ltd ).
>
> Sorry I'm facing this problem for weeks, I can't find a solution.
>
> Is there a known workaround for it ?
Hi Team,
Is SQLite supports outfile query and dumps all data into specified file format
?
I have tried to extract data from table using outfile query but query failed
status returned. If supports , Can you please share the syntax or example that
will really help lot to me.
Awaiting for your
I have some of my own ideas about this.
* Perhaps move PARAMETERS before AS, which may make the syntax easier.
* You don't need computed columns in tables; use views instead. You can index
computed values though.
* I do agree that defining table-valued functions in these way can be useful
thou
Hi,
Our project did a SQLite version bump from 3.23.1 to 3.24.0 (identical build
options), the /usr/lib/libsqlite3.so.0.8.6 lib increased by 20% !
3.24.0
-rwxr-xr-x1 root root814112 Jun 10 15:31
/usr/lib/libsqlite3.so.0.8.6 (uses libm)
3.23.1
-rwxr-xr-x1 root root
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-
Hello! I noticed that there was some discussion about mailing list
messages getting sent to spam boxes. So, not that I expect an immediate
answer, but just in case people didn’t see this message for that
reason, here it is again. It seemed potentially odd that many other
threads got replies but thi
On 6/10/18, Lonnie Abelbeck wrote:
>
> Our project did a SQLite version bump from 3.23.1 to 3.24.0 (identical build
> options), the /usr/lib/libsqlite3.so.0.8.6 lib increased by 20% !
>
> 3.24.0
> -rwxr-xr-x1 root root814112 Jun 10 15:31
> /usr/lib/libsqlite3.so.0.8.6 (uses libm)
On 6/11/18, Christopher Head wrote:
> Hello! I noticed that there was some discussion about mailing list
> messages getting sent to spam boxes. So, not that I expect an immediate
> answer, but just in case people didn’t see this message for that
> reason, here it is again. It seemed potentially od
On 06/11/2018 05:35 AM, Lonnie Abelbeck wrote:
Hi,
Our project did a SQLite version bump from 3.23.1 to 3.24.0 (identical build
options), the /usr/lib/libsqlite3.so.0.8.6 lib increased by 20% !
For version 3.24.0, the fts5 and json1 extensions are enabled by default
in the amalgamation/auto
Dear all,
Thanks for your help. It works !
Peter
> Am 11.06.2018 um 11:14 schrieb Tim Streater :
>
>> On 11 Jun 2018, at 09:07, Peter Nacken wrote:
>>
>> I try to insert email addresses into a table and get an error with addresses
>> they have a single quotation mark ( na'm...@domain.ltd ).
On 6/11/18 4:23 AM, Olivier Mascia wrote:
>> Le 11 juin 2018 à 10:07, Peter Nacken a écrit :
>>
>> I try to insert email addresses into a table and get an error with addresses
>> they have a single quotation mark ( na'm...@domain.ltd ).
>> Sorry I forgot I‘m using C#
> (Assuming: "create table T(
Very good point. I think that everyone should do it that way. It is a bit
more work, but is vastly superior.
On Mon, Jun 11, 2018, 03:23 Olivier Mascia wrote:
> > Le 11 juin 2018 à 10:07, Peter Nacken a écrit :
> >
> > I try to insert email addresses into a table and get an error with
> address
On 9 Jun 2018, at 6:36pm, Guna Sekar wrote:
> Is SQLite supports outfile query and dumps all data into specified file
> format ?
I don't understand your question, but you might want to use the command-line
shell program to dump a database to a text file -- either as SQL commands or a
CSV fil
On 11 Jun 2018, at 8:29am, Christopher Head wrote:
> It seemed potentially odd that many other
> threads got replies but this didn’t.
Your question was so good nobody had an answer to it. I hope you see that DRH
has now posted a reply, even if that reply doesn't include a solution.
Simon.
___
On 6/11/18, Lonnie Abelbeck wrote:
>
> What changed for 3.23.1 -> 3.24.0 to cause such a large increase in library
> file size?
>
See Dan's follow-up. Beginning with 3.24.0, the FTS5 and JSON1
extensions are enabled by default.
Manually edit the Makefile generated by ./configure to turn off tho
On 6/11/18, Richard Hipp wrote:
> On 6/11/18, Lonnie Abelbeck wrote:
>>
>> What changed for 3.23.1 -> 3.24.0 to cause such a large increase in
>> library
>> file size?
>>
>
> See Dan's follow-up. Beginning with 3.24.0, the FTS5 and JSON1
> extensions are enabled by default.
Checking further, I
I'm surprised about the commit time of SQLite, when writing blobs is
involved.
Can anybody shed light on this subject? Below's a description of what I do,
with the results.
I've exporting data into SQLite, spread in several tables.
I process only about 240,000 rows, and write around 1GB in 20,000
Dominique Devienne wrote:
> My assumption
> was that after the zeroblob(N), there was enough room in the main DBs
> pages, such that the subsequent blob open+write+close did not need to
> generate any "page churn" (i.e. journal activity) and could write directly
> to the pages created on initial in
On 6/11/18, Lonnie Abelbeck wrote:
>
>> On Jun 11, 2018, at 7:23 AM, Richard Hipp wrote:
>>
>> On 6/11/18, Lonnie Abelbeck wrote:
>>>
>>> What changed for 3.23.1 -> 3.24.0 to cause such a large increase in
>>> library
>>> file size?
>>>
>>
>> See Dan's follow-up. Beginning with 3.24.0, the FTS5
On Mon, Jun 11, 2018 at 4:27 PM Clemens Ladisch wrote:
> Dominique Devienne wrote:
> > My assumption
> > was that after the zeroblob(N), there was enough room in the main DBs
> > pages, such that the subsequent blob open+write+close did not need to
> > generate any "page churn" (i.e. journal acti
If FTS5 is enabled by default in the amalgamation, the documentation needs
to be updated.
https://sqlite.org/fts5.html Section 2.1
On Mon, Jun 11, 2018 at 9:57 AM Richard Hipp wrote:
> On 6/11/18, Lonnie Abelbeck wrote:
> >
> >> On Jun 11, 2018, at 7:23 AM, Richard Hipp wrote:
> >>
> >> On 6
Specifically, preparation of the "trigger part" of the statement is
the overhead? Correct?
On Mon, Jun 11, 2018 at 5:16 PM, Keith Medcalf wrote:
>
> Okay, the difference is the "lots of inserts" -vs- the "one insert".
>
> When I do the same thing (dump the contents of the table to a file and the
Trying again/
Specifically, preparation of the constant "trigger part" of the statement is
the overhead? Correct?
On Tue, Jun 12, 2018 at 9:47 AM, David Burgess wrote:
> Specifically, preparation of the "trigger part" of the statement is
> the overhead? Correct?
>
>
> On Mon, Jun 11, 2018 at 5:16
Yes. Looking up the trigger and preparing the VDBE code appears to the
additional time spent.
---
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...@
Dominique Devienne wrote:
> On Mon, Jun 11, 2018 at 4:27 PM Clemens Ladisch wrote:
>> It does write to the same pages, but those pages must be copied to the
>> rollback journal so that they can be restored if the transaction is
>> rolled back. (Or are the two passes inside the same transaction?)
30 matches
Mail list logo