[sqlite] Article with time trials for SQLite INSERT command

2016-11-12 Thread Simon Slavin
Mike Willekes tests how fast INSERT runs under many different conditions, with results from 85 inserts per second to 96,000 inserts per second. Simon. ___

Re: [sqlite] Is it possible to connect to an in-memory sqlite db in Read-Only mode?

2016-11-12 Thread Simon Slavin
On 11 Nov 2016, at 12:28pm, Bhargava Srinarasi wrote: > I know that I can open multiple connections to an In-Memory sqlite database > using file:DB_NAME?mode=memory=shared in sqlite3_open_v2(). > > I open 2 connections to an In-Memory database. One with the flags >

Re: [sqlite] BUG: crash in fts5MultiIterNext()

2016-11-12 Thread Dan Kennedy
On 11/13/2016 01:58 AM, Jan Berkel wrote: Got a crash in the FTS5 code which only happens on a specific search query (int the form of: "ab cd" OR "ab cd" *) The crash occurs In fts5MultiIterNext(), on the following line: pSeg->xNext(p, pSeg, ); Debugger shows that pSeg is set, but xNext is

[sqlite] BUG: crash in fts5MultiIterNext()

2016-11-12 Thread Jan Berkel
Got a crash in the FTS5 code which only happens on a specific search query (int the form of: "ab cd" OR "ab cd" *) The crash occurs In fts5MultiIterNext(), on the following line: pSeg->xNext(p, pSeg, ); Debugger shows that pSeg is set, but xNext is null. There are items which match the

Re: [sqlite] Merging FTS indexes

2016-11-12 Thread Jan Berkel
> Why not simply query all databases and merge the results in the > application? I would think that would perform equally well, and the > merging > is likely straightforward to implement… Yes I was thinking about that a well, just wanted to check if there was already some code for the merging

Re: [sqlite] Encryption

2016-11-12 Thread Chris Locke
Encryption in system.data.sqlite is legacy encryption, only used within itself, and not with other applications. On Fri, Nov 11, 2016 at 6:24 PM, Richard Andersen wrote: > > > I'm using the ADO.NET version (System.Data.SQlite). > > I've created an RSA encrypted database using

[sqlite] Is it possible to connect to an in-memory sqlite db in Read-Only mode?

2016-11-12 Thread Bhargava Srinarasi
I know that I can open multiple connections to an In-Memory sqlite database using file:DB_NAME?mode=memory=shared in sqlite3_open_v2(). I open 2 connections to an In-Memory database. One with the flags SQLITE_OPEN_URI | SQLITE_OPEN_CREATE | SQLITE_OPEN_READWRITE and another with