On 16 Nov 2010, at 10:18pm, Bernard Ertl wrote:
> 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, s
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 messag
On Tue, 16 Nov 2010 14:07:34 -0800 (PST), Bernard Ertl
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
--
( Kees Nuyt
)
c[_]
___
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.
___
Do you have recursive triggers enabled?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 U
On 11/16/2010 06:25 AM, Bernard Ertl wrote:
> 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 afte
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
becau
I have a table
CREATE TABLE foo (
foo_id INTEGER PRIMARY KEY,
foo_name TEXT,
foo_text TEXT
);
I have created a virtual table to do full text search
CREATE VIRTUAL TABLE fts_foo (
USING fts2(foo_text);
I have populated this table
INSERT INTO fts_foo (rowid, foo_text)
VALUES (foo.foo_id, f
9 matches
Mail list logo