Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.