Talking about the difference between MySQL and Access database

Intermediary trading SEO diagnostic Taobao guest hosting technology hall

As we all know, PHP and ASP.NET are required to build a station, some time ago Xiaobian have to share with you the difference between building these two companies choose; However, there are many novice webmaster said it was unclear how to use MySQL and Access database, today is small For everyone to make a simple analysis of the difference between the two.

What is MySQL and Access?

Microsoft Office Access is a database management system that Microsoft combines with the database engine's graphical user interface and software development tools. It stores its data in an Access Jet-based database engine in its own format. Data can be imported directly or linked to data. Access supports the Visual Basic Macro Language, an object-oriented programming language that cites various objects, including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components.

MySQL is an open source relational database management system, the associated database to save the data in different tables, increasing the speed; MySQL SQL language used to access the database is the most commonly used standardized language. Features are small, fast, low cost, open source, because of its open source, so many small and medium sites in order to reduce the total cost of ownership of the site, so choose MySQL as the site database.

The difference between MySQL and Access

MySQL features: very cheap, usually free; less network hosting; query optimization; easy backup of applications through MySQL; MySQL easy to use, easy to use, and for a variety of different data formats to provide a flexible extension of the interface ODBC).

Access Features: Easy to learn, easy to use, high development efficiency.

Price: MySQL is free for most users, but you will pay a small license fee if you are using MySQL inline or using only MySQL commercial software. Access is more expensive.

Concurrent Processing: The number of connections that Access can handle is unlimited, but the connection must remain within the bounds of concurrent processing; MySQL defaults to a maximum of 100 users, but not even if there is a large amount of data on the network Too much query optimization on MySQL.

Data Update: MySQL can update data significantly faster than Access using the same hardware and data sizes on Windows 98, handling hundreds of thousands of data, but Access can outperform MySQL if it deals with object structure. When creating tables and indexes, MySqL locks the tables, slowing down the vast amount of data being processed, which ensures the speed of queries when users come in and does not affect website development.

Structural optimization: MySQL only need to optimize the hardware conditions, rather than MySQL itself; Access database is very efficient, of course, it also depends on the site's structural design; MySQL does not support foreign keys, optimizing pay attention to how to reduce access IO The lowest value, how to keep one or more CPUs at high speed at any time, and the appropriate network bandwidth, rather than the actual design and data query.

Data Backup: MySQL Dump will produce a much better and more reliable backup file than Access. In contrast, in Access you just copy an MDB file for backup. Second, even if some of MySQL's backups are corrupted, it is much easier to recover than a corrupt MDB file.

Data processing capabilities: MySQL data processing capabilities than Access; eg: If you deal with 100MB of MySQL files, there will be no signs of overloading, and Access will result in inefficient website.

MySQL Disadvantages: can not handle complex associative functions; does not support transactional and transaction commit / undo; MySQL does not support foreign keys and reference integrity restrictions, so MySQL does not apply to applications that have complex data relationships, but Access can ; And MySQL does not store processes and triggers. When there are many forms that need to be updated at the same time in one transaction, MySQL is slower.

This article by: laser cutting machine http://www.laser568.com/ finishing release, reproduced, please explain.