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
