This is turning OT, but imho the best reason for stored procedures is that the query plan is precompiled. Free-standing SQL necessitates the creation of a query plan by the compiler/optimizer on ever call. It's all about speed.
The other good reason is that generally auditing is easier on stored procs, and free-standing SQL is harder to profile from the database side. H Mitsuda, Alex wrote: > Problem is probably more on the database side. It doesn't matter very much > which drivers are being used, I've used ODBC, DBD:Sybase, and Win32::OLE > against MS SQLServer. I've heard alot of good things about MySQL, only > downside being no stored procedures. Best reason for stored procedures: > allows you to move alot of work to the database engine instead of handling > in the application. > > -----Original Message----- > From: Brad Smith [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 09, 2002 1:25 AM > To: [EMAIL PROTECTED] > Subject: I need a more efficient driver > > > At present, I am using the DBI module to open Access databases. As > the databases are rapidly growing, the performance is decreasing > greatly. > > If you had the following alternative options, which one would you > choose? > 1. MS SQL Server with corresponding MS SQL driver. > 2. MySQL Server with MyODBC driver. > 3. MySQL Server with MS SQL driver. > > Thanks in advance for offering advice. I don't know enough about how > each of these servers and drivers compares. > > Sincerely, > Brad Smith > This message contains confidential information and is intended only for the > individual named. If you are not the named addressee you should not > disseminate, distribute or copy this e-mail. Please notify the sender > immediately by e-mail if you have received this e-mail by mistake and delete > this e-mail from your system. > E-mail transmission cannot be guaranteed to be secure or error-free. The > sender therefore does not accept liability for any errors or omissions in > the contents of this message that arise as a result of e-mail transmission. > This message is provided for informational purposes and should not be > construed as a solicitation or offer to buy or sell any securities or > related financial instruments. > All e-mails at Neuberger Berman are, in accordance with Firm policy, to be > used for Neuberger Berman business purposes only. E-mails sent from or to > the Firm are subject to being reviewed by the Firm in accordance with the > Firm's procedure for the review of correspondence > -- Henri Asseily BizRate.com [EMAIL PROTECTED] The best shopping experience! Chief Technologist http://www.bizrate.com/ "Apprends mon ami que la situation la mieux assise ne r�siste pas au pal." Iznogoud
