Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
When you say "a stored procedure that runs after every insert," do you mean it's run by an AFTER INSERT trigger, which is FOR EACH ROW and 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
Yes that's what I want – Lucas Kauffman May 31 '13 at 4:53

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.