Q: Stored proceduces vs. Trigger
Posted in 1998
Topics: Stored Procedures & SPL, Triggers, Constraints & Referential Integrity
This is a multi-part message in MIME format. --------------9BB50D6F865B14E5D58E1CE1 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 ? Any input appreciated! Thanks Marc --------------9BB50D6F865B14E5D58E1CE1 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for mielke@glamus.de Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: mielke@glamus.de n: ;mielke@glamus.de email;internet: mielke@glamus.de x-mozilla-cpt: ;0 x-mozilla-html: FALSE version: 2.1 end: vcard --------------9BB50D6F865B14E5D58E1CE1--