Re: [sqlite] Multi threaded readers on memory sqlite cannot scale

hub.com/LMDB/sqlightning > ?On 5/14/18, 8:47 AM, "sqlite-users on behalf of Bernard Ertl" > <sqlite-users-boun...@mailinglists.sqlite.org on behalf of > bern...@interplansystems.com> wrote: > This is the latest: > http://www.sqlitening.planetsquires.com/ind

Re: [sqlite] Multi threaded readers on memory sqlite cannot scale

This is the latest: http://www.sqlitening.planetsquires.com/index.php?topic=9427.0 I contributed to the last SQLitening update. No one has reported any issues that need fixing or updating since that update. It seems to be working quite well/stable. > On 5/13/18, 6:48 AM, "sqlite-users on

Re: [sqlite] How to use "cursors" in c#

> ... If your application requires concurrent network access, you should be > using either a network client/server DBMS or programming your own > Client/Server pair with the server process calling the SQLite API to modify > the db file held on the servers' local filesystem. ... There is an

[sqlite] Referencing a column alias (subquery) as function parameter

Is it possible to do something like this: SELECT c1, c2, CurrentDate, (CASE ActiveCol WHEN 0 THEN c3 ELSE c4 END) AS ac, MyFn(c1,ac,CurrentDate) AS xc1, MyFn(c2,ac,CurrentDate) AS xc2 FROM ... where c1, c2, CurrentDate, ActiveCol, c3, c4 are all columns in the table(s) referenced in the

Re: [sqlite] Using foreign key reference on RowID

their database! Jay A. Kreibich-2 wrote: > > On Wed, Nov 17, 2010 at 04:36:12PM -0600, Bernard Ertl scratched on the > wall: > >> Is it not possible to reference the SQLite >> internal/default column for the RowID in a foreign key definition? > > Even if y

Re: [sqlite] Using foreign key reference on RowID

: > > On Wed, 17 Nov 2010 16:36:12 -0600, "Bernard Ertl" > <bern...@interplansystems.com> wrote: > >>I'm getting a "foreign key mismatch" error with the following code: >> >>~~~ >> >>PRAGMA foreign_keys = ON; >> >>CREATE T

[sqlite] Using foreign key reference on RowID

I'm getting a "foreign key mismatch" error with the following code: ~~~ PRAGMA foreign_keys = ON; CREATE TABLE IF NOT EXISTS JobPlans (Name UNIQUE); CREATE TABLE IF NOT EXISTS Tasks (JobPlan_ID INTEGER NOT NULL REFERENCES JobPlans(RowID) ON DELETE CASCADE, UID UNIQUE NOT NULL); INSERT INTO

Re: [sqlite] Trouble with TRIGGERS

Kees Nuyt wrote: > >> Nicolas Williams-2 wrote: >> > Do you have recursive triggers enabled? >> >> I'm not sure. How do I check? > > http://www.sqlite.org/pragma.html#pragma_recursive_triggers > I'm not using any pragma commands, so no, I'm not using recursive triggers. -- View this

Re: [sqlite] Trouble with TRIGGERS

Nicolas Williams-2 wrote: > Do you have recursive triggers enabled? I'm not sure. How do I check? -- View this message in context: http://old.nabble.com/Trouble-with-TRIGGERS-tp30228089p30233496.html Sent from the SQLite mailing list archive at Nabble.com.

Re: [sqlite] Trouble with TRIGGERS

Dan Kennedy-4 wrote: > > Sounds like it. > > Calling sqlite3_prepare_v2() generates the VM code for all > triggers that could possibly be invoked by your statement. > All it considers when determining which triggers might be > needed is the type of statement (UPDATE, DELETE, INSERT) and > for

[sqlite] Trouble with TRIGGERS

Hi, I'm experiencing some performance issues with triggers at the moment and hoping someone can help shed some light on what is happening. I have a database with ~20 tables and >100 triggers. I noticed a severe performance degradation after adding the last few triggers and it puzzled me