This topic is locked

SQL Server vs MySQL vs Access

12/22/2006 3:08:31 PM
ASPRunnerPro General questions
author

Can anyone give me a short primer on the advantages and disadvantages of these three platforms? And - how does ASPRunnerPro handle them?
I'm trying to find the fastest platform for a new project.
Thanks
shipman05@gmail.com

Sergey Kornilov admin 12/22/2006

Here is the short summary from my database experience.
MS Access

Easy manageable database. Perfect for small applications that don't expect a large amount of data and simultaneous users.

If you plan to have more than 20 users accessing database at the same time choose more advanced database.

All Windows-based web hosting companies support MS Access
MySQL

Handles large number of users easily. Handles databases up several hundred megabytes without any problems.

ASP support relies on MySQL ODBC drivers that are somehwat buggy. Works better with PHP.

Many Windows-based web hosting companies provide MySQL support as an option.
SQL Server

The most reliable database engine on this list. Handles large volumes of data and large number of simultaneous users.

We have choosen SQL Server as a database for hosted Gulfstream Helpdesk product.
According to what I learned about your project from other posts SQL Server is the only database that you can use.
How does ASPRunnerPro handles all of them. Well, hmmm ..., it handles them.

501279 12/26/2006

Here is the short summary from my database experience.

MS Access

Easy manageable database. Perfect for small applications that don't expect a large amount of data and simultaneous users.

If you plan to have more than 20 users accessing database at the same time choose more advanced database.

All Windows-based web hosting companies support MS Access
MySQL

Handles large number of users easily. Handles databases up several hundred megabytes without any problems.

ASP support relies on MySQL ODBC drivers that are somehwat buggy. Works better with PHP.

Many Windows-based web hosting companies provide MySQL support as an option.
SQL Server

The most reliable database engine on this list. Handles large volumes of data and large number of simultaneous users.

We have choosen SQL Server as a database for hosted Gulfstream Helpdesk product.
According to what I learned about your project from other posts SQL Server is the only database that you can use.
How does ASPRunnerPro handles all of them. Well, hmmm ..., it handles them.


Thanks for the rundown of the various platforms... My host does provide MS SQL, and I would love to switch to this from Access, but the problem I'm facing now is setting up a local ODBC connection so I can use APRunnerPro!! Until I figure out how to set up MS SQL on my local machine I'm going to continue in Access and try to maximize the speed of the thing...
Thanks again.

C
clig 12/30/2006



Thanks for the rundown of the various platforms... My host does provide MS SQL, and I would love to switch to this from Access, but the problem I'm facing now is setting up a local ODBC connection so I can use APRunnerPro!! Until I figure out how to set up MS SQL on my local machine I'm going to continue in Access and try to maximize the speed of the thing...
Thanks again.


If I understand what you are saying why use ODBC (DSN)... Go with a DSN less connector:
<%

strConnection = "DRIVER=SQL Server;SERVER=machinename;UID=username;PWD=password;APP=App;WSID=machinename;DAT

ABASE=databasename;Network=DBMSSOCN"

%>

  • You can develop locally on the same lan with IIS on your workstation
  • this won't work obviously over the internet unless they have the port open (unlikely) - You could find a copy of MSDE for local dev or possibly just go with Microsoft SQL Server 2005 Express Edition...