MySQL Forums
Forum List  »  Stored Procedures

SP vs Trigger
Posted by: JOHN VILLEGAS
Date: September 19, 2005 10:06AM

Hi everyone,

I have a question about performance... What have a better performace a store procedure or a trigger? The thing is that this trigger have too many sentences and some buisiness logic and some times the response time is not too good, so, do you think that if I put some of the parts of the trigger in a sp that will help to the response time??

Thak you very much..

Options: ReplyQuote


Subject
Views
Written By
Posted
SP vs Trigger
3019
September 19, 2005 10:06AM
2384
September 21, 2005 06:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.