Jim Lawrence (AccessD)
accessd at shaw.ca
Wed Oct 27 13:32:12 CDT 2004
Hi Barb: These comments are from my observations: 1. Using MySQL is slower than Access DAO when working with small to medium sized tables and having to use an ODBC driver adds another performance hit. The lose in performance is totally connection related. 2. MySQL's tables can exceed 2GB, still runs fast, even with huge files and of course it is free. 3. MS SQL does not need an ODBC drive, handles huge files, runs very fast and has an awesome set of features but can be considered expensive. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Barbara Ryan Sent: Wednesday, October 27, 2004 11:14 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access with a MySQL database Thanks, Marty.... I had looked at this site as well as several others on the Web. I think that my main question is a performance issue --- since MySQL does not use server side cursors, is there any performance advantage over using the existing Access back-end? I could also use a SQL Server back-end using ODBC. However, it is my understanding that I would need modify code (SQL statements, queries, etc) in the Access front end to optimize performance using SQL Server (vs. an Access back-end). I am not an expert in any of this my any means, so please correct me if I've spoken heresy! Again, some considerations are that my client currently does not own SQL Server but is using MySQL in their web application. Thanks, Barb Ryan ----- Original Message ----- From: "MartyConnelly" <martyconnelly at shaw.ca> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Wednesday, October 27, 2004 10:43 AM Subject: Re: [AccessD] Access with a MySQL database > Something I came across from an ASP perspective > http://www.aspfree.com/c/a/Microsoft-Access/An-Access-Front-End-to-MySQL/ > > Barbara Ryan wrote: > > >Does anyone have any experience using an Access application as a front-end to a MySQL database back-end? My client is interested in converting the Access back-end to either SQL Server or MySQL. They currently do not own SQL Server but are using MySQL in their web application. > > > >Any thoughts (advantages, limitations, etc.)? > > > >Thanks, > >Barb Ryan > > > > > > -- > Marty Connelly > Victoria, B.C. > Canada > > > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com