Le mercredi 11 juillet 2007 à 12:47 -0400, Igor Tandetnik a écrit : > Be aware that SQLite never enters infinite loop of triggers. It keeps > track of a chain of nested triggers that led to the currently executing > statement; if that statement would fire a trigger that is already in the > chain, the trigger does not run. > > Notice how, in my solution, a BEFORE INSERT trigger runs an INSERT on > the same table, with no ill effects. Yes... So I don't know why but only with 4 triggers, I made my database become very slow. On some requests, it was "calculating" while 10 sec, and after an core dump happends... -- Charly CAULET
membre de www.208assistance.org ID jabber : [EMAIL PROTECTED] clé gpg : 0x7DE10F3C (pgp.mit.edu)
signature.asc
Description: Ceci est une partie de message numériquement signée