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

2011-04-20 Thread Kenneth Ballard
the application code a little. Let me know if you have any luck reproducing the issue. Kenneth On 4/16/2011 8:09 PM, Richard Hipp wrote: 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

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

2011-04-16 Thread Kenneth Ballard
L CONSTRAINT [fk_tablec_tablee] REFERENCES [table_e]([col_a]), [col_c] TEXT NOT NULL); And the sqlite_stat1 table data: table_a,,1 table_b,idx_tableb_tablec_tabled,6745 42 1 table_c,974 On 4/16/2011 4:35 PM, Kenneth Ballard wrote: > Good afternoon, > > Here is an issue I started to exper

[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