A multithreaded database solution like MySQL would be able to treat multiple visitors at the same time without slowing down the web site.
MySQL is a relational database management system (RDBMS) that: provides users with a powerful multi-user, multi-threaded SQL (Structured Query Language) database solution. Microsoft Access is a single-threaded system. This means it deals with requests one at a time
MySQL is significantly faster and more robust than Microsoft Access.
MS Access cannot cope effectively with more than 5 concurrent users. My SQL by default can cope with 100 concurrent users without any loss of performance.
Low End Solution | Mid Way Solution | High Mid Way | High End Solution | |
MS Access | MySQL | MS SQL | Oracle 9i | |
Cost of Developing | Within Budget | Reasonable | Expensive | Very Expensive |
Advantages | Ideal for testing a prototype systemSkills, wide spread.Little or no Maintenance
Costs as the functional specification includes web site administration. |
MySQL is one of the most used open source databases in the world.Its free and available over the world wide webAbility to handle an unlimited number of simultaneous users.
Capacity to handle 50,000,000+ records. Very fast command execution, perhaps the fastest to be found on the market. Easy and efficient user privilege system. |
Supports MS SQL Server specific featuresSimplifies data updatingSpeeds up fetch of records from database
Provides automatic refresh for records Advanced design time editors |
Suitable for very large corporate e-commerce solutionsImproved throughputScalability over single instance systems
Improved response time High availability Transparency |
Disadvantages | Mainly Suitable for SME’s | Skills and support scarce and can be expensiveMaintenance costs high | Skills and support very scarce and expensiveMaintenance costs expensive |