Olivier Mascia wrote: > As far as I understood, SQLite will parse and compile the trigger text > as part of each statement using them. No bytecode compilation upfront, > nor storage of it.
SQLite parses all triggers (and all other schema objects) when it reads the schema (see "struct Trigger" and "struct TriggerStep" in the source). However, the bytecode for them is generated only when the actual query is prepared (see "struct TriggerPrg" and "struct SubProgram"). Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users