I have an application which periodically will insert large amounts of data, from that data I build a few materialized views (well emulate by creating a table from a view and replacing it with the current one since MySQL does not support materialized views), this is done with a stored procedure which runs after every insert.
Would it be possible to run the procedure automatically after committing the transaction?
AFTER INSERTtrigger, which isFOR EACH ROWand you're wanting to delay that action until the entire group of inserts is done (and committed) to speed up the overall process? – Michael - sqlbot May 31 '13 at 2:51