Re: Q: Stored proceduces vs. Trigger

Marc Mielke wrote: > > Hi to all, > > does anybody have experience on how stored procedures > perform compared to triggers ? > > I.e: Is an statement (insert, delete, update) called from inside a > stored procedure > faster or slower as the same one beeing triggered by some appropiate > event ? > > Is there a at all a difference (from the point of view of the engine) > between executing stored procedures and trigger code ? The implementation of the trigger code and stored procedure code are almost identical. I imagine the only difference is that the stored procedure must be explicitely executed or called from a trigger while the trigger fires when it's triggering event occurs. It really comes down to whether you need manual or automatic action. If both program the stored procedure for manual executions and call it from the trigger for automated firing. Art S. Kagel