On 3 Feb 2011, at 7:41pm, Petite Abeille wrote: > On Feb 3, 2011, at 6:53 PM, Kevin Wojniak wrote: > >> The trigger is ran once via sqlite3_exec(); > > Hmm... you mean the trigger is run every single time you perform an insert, > no? > >> Any insight as to why the trigger is significantly slower? > > It adds significant overhead for each and every insert.
But his alternative to doing INSERT with a TRIGGER is to do an INSERT and then a manual UPDATE. Are triggers really so inefficient that it's that much faster to do it manually ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
