For one they get around the problem of getting the last id inserted into the table as per some of the discussion in the MySQL thread yesterday, without needing to use serializable transactions. Procedures are also often pre-compiled, so they may run faster, even the first time they are executed, although on an insert this probably doesn't make much difference.
-----Original Message----- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Tuesday, 7 June 2005 11:57 To: CF-Talk Subject: Re: Get New Record ID in ORACLE What type of advantages does an SP in oracle(or whatever) have over queries for basic DB inserts? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208764 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
