Re: [sqlite] SQLite 3.7.6 and 3.7.6.1 -- Performance issue with Triggers

2011-04-21 Thread kball...@kennethballard.com
I created the two additional indexes and ran some timing tests on the applicable tables and the timings came out much faster than anything I'd seen before, so thank you very much for your help on this.   It is very interesting that you found the query to be performing "universally slow" all the way

Re: [sqlite] SQLite 3.7.6 and 3.7.6.1 -- Performance issue with Triggers

2011-04-20 Thread Richard Hipp
On Sat, Apr 16, 2011 at 5:35 PM, Kenneth Ballard < kball...@kennethballard.com> wrote: > Good afternoon, > > Here is an issue I started to experience after upgrading from SQLite > 3.7.5 to 3.7.6 involving a trigger I have on a database table. > Using the database you sent me by private email, I f

Re: [sqlite] SQLite 3.7.6 and 3.7.6.1 -- Performance issue with Triggers

2011-04-20 Thread Richard Hipp
On Wed, Apr 20, 2011 at 12:37 AM, Kenneth Ballard < kball...@kennethballard.com> wrote: > Okay I'm going to just give up on creating a specific test case for this > one and I'm just attaching the original database file. Every time I tried to > isolate out just the tables applicable to the trigger

Re: [sqlite] SQLite 3.7.6 and 3.7.6.1 -- Performance issue with Triggers

2011-04-20 Thread Kenneth Ballard
Okay I'm going to just give up on creating a specific test case for this one and I'm just attaching the original database file. Every time I tried to isolate out just the tables applicable to the trigger code, the issue is not reproducible. So attached to this message is the database in questio

Re: [sqlite] SQLite 3.7.6 and 3.7.6.1 -- Performance issue with Triggers

2011-04-16 Thread Richard Hipp
On Sat, Apr 16, 2011 at 6:29 PM, Kenneth Ballard < kball...@kennethballard.com> wrote: > The schema for these two tables is unchanged between the 3.7.5 and 3.7.6 > version with the exception of the sort modifiers on table_b's unique index. > Using the schema and sqlite_stat1 data you provide, I g

Re: [sqlite] SQLite 3.7.6 and 3.7.6.1 -- Performance issue with Triggers

2011-04-16 Thread Kenneth Ballard
The schema for these two tables is unchanged between the 3.7.5 and 3.7.6 version with the exception of the sort modifiers on table_b's unique index. Table table_b: CREATE TABLE [table_b] ( [col_a] INTEGER NOT NULL CONSTRAINT [fk_tableb_tablec] REFERENCES [tablec]([col_a]) ON DELETE CASCADE,

Re: [sqlite] SQLite 3.7.6 and 3.7.6.1 -- Performance issue with Triggers

2011-04-16 Thread Richard Hipp
On Sat, Apr 16, 2011 at 5:57 PM, Richard Hipp wrote: > > > On Sat, Apr 16, 2011 at 5:35 PM, Kenneth Ballard < > kball...@kennethballard.com> wrote: > >> Good afternoon, >> >> Here is an issue I started to experience after upgrading from SQLite >> 3.7.5 to 3.7.6 involving a trigger I have on a dat

Re: [sqlite] SQLite 3.7.6 and 3.7.6.1 -- Performance issue with Triggers

2011-04-16 Thread Richard Hipp
On Sat, Apr 16, 2011 at 5:35 PM, Kenneth Ballard < kball...@kennethballard.com> wrote: > Good afternoon, > > Here is an issue I started to experience after upgrading from SQLite > 3.7.5 to 3.7.6 involving a trigger I have on a database table. > > The table with the trigger is a 2-column table with

[sqlite] SQLite 3.7.6 and 3.7.6.1 -- Performance issue with Triggers

2011-04-16 Thread Kenneth Ballard
Good afternoon, Here is an issue I started to experience after upgrading from SQLite 3.7.5 to 3.7.6 involving a trigger I have on a database table. The table with the trigger is a 2-column table with the following trigger installed to it: CREATE TABLE [table_a] ( [col_a] INTEGER NOT NULL PR