mysql or acces
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=16006
Printed Date: 29 March 2026 at 10:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: mysql or acces
Posted By: pilot99
Subject: mysql or acces
Date Posted: 28 July 2005 at 12:04am
| im confused which is better and witch works better with asp? |
Replies:
Posted By: zaboss
Date Posted: 28 July 2005 at 1:24am
|
Both work OK with ASP and there are plenty of ASP aplications that are
designed to work with MySQL, SQL Server, Access. The only problem is
usage. Access is suitable for small sites, with little traffic, while
both MS SQL and MySQL are able to handle large traffic with practicaly
no limit. There are though minor code changes in SQL statements. ------------- Cristian Banu http://www.soft4web.ro - Soft 4 web |
Posted By: dpyers
Date Posted: 28 July 2005 at 1:40am
mssql  Seriously though, it depends upon what you want to do with it. Most of the asp programming examples you'll find will be for mssql or access. Access has severe limitations as a web database. Not the least of which is that you have to put it outside of your web root to even start to secure it and the entire db loads into memory to execute a query. It's a flat file and not a true relational db so when you delete a record, it only flags that area in the file as deleted and does not re-use the empty space. You need to do periodic compact and repairs to clean it up. "Access" is not actually a data base. It's a MS office program that has used a variety of different data bases over the years. Currently it ships with the Jet db engine. The next release will see it ship with a "MS SQL-Light" engine but how that's going to be implemented in a web hosting environment is up for discussion. MS SQL generally has more features than MySQL and/or better implementation of many db services. MySQL only implemented stored procedures relatively recently (think of stored procs as compiled binary versions of queries - they run much faster), and doesn't support "views" of the db. My personal feeling is that the new mssql 2005 beta is faster than mysql overall but that's more of a hunch than a fact. MSSQL 2005 is up for release this fall. Expect to see the light version incorporated into the next release of Access/MS Office next year. MySQL is faster for many types of queries though so it depends upon your application as to if mssql 2000 or mysql 4.x would be faster. The conventional wisdom for shared hosting is to use mssql for developing web apps for windows servers and mysql for unix servers and avoid ms access. Corporate web apps will use Oracle, Informix, or DB2. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: dpyers
Date Posted: 28 July 2005 at 1:44am
lol - I remember when the SQL standard came out -the acronym meant "Standard" Query Language - for 3 weeks anyway  . -------------
Lead me not into temptation... I know the short cut, follow me. |
zaboss wrote:Posted By: pilot99
Date Posted: 28 July 2005 at 6:31pm
| thanks i was going to make a simple web portal that ran from a database but im only learning now about databases can anyone help me learnn about qeuries or post good tutorials. |
Posted By: aks427
Date Posted: 28 July 2005 at 10:07pm
| Go to http://www.w3schools.com - http://www.w3schools.com . They should be able to get you started pretty good. |