The difference and definition between access and mysql
This article mainly introduces the difference and definition between access and mysql, the things involved, learned from the theoretical knowledge, there are many books and documents for your reference, from the perspective of practical significance, accumulated years of practical experience can be shared with you.
A friend asked access or mysql which is useful. This is the same as saying which of the two people is better. This all depends on the situation, specific analysis of specific problems, here the editor would like to talk to you.
Give me a brief introduction.
Access is a file-based database and MySQL is a cloud server-based database.
File-based database can also be called embedded database, it can only be accessed on a single machine, does not need additional independent processes, and takes up relatively few resources.
Server-based databases can be run across hosts via IP addresses, requiring additional processes to run it.
Each has its own advantages and disadvantages:
As a file-based database, access is relatively lightweight, occupies less resources and is easy to operate. The disadvantage is that it is only suitable for scenarios where the total amount of data is small and the data throughput is low. For example, the configuration used to store programs is a good choice, often used in clients, stand-alone applications and small websites. If you choose large servers such as MySQL at this time, it will feel like killing a chicken with a knife.
On the other hand, large-scale systems are more suitable to use MySQL, especially when the total amount of data is very large and read and write frequently. Typical applications are large and medium-sized websites, game servers, and those with a lot of visitors at the same time. Because MySQL is a server, it also supports multiple applications (including servers) to access at the same time for data sharing and exchange, which is difficult for access to do.
To sum up, who is more useful depends on the situation. When the total amount of data is small and the data throughput is low, you can use access. Using mysql is a bit like killing a chicken with a knife. On the other hand, large-scale systems are more suitable to use MySQL, especially when the total amount of data is very large and read and write frequently.
The above is the difference and definition between access and mysql, please pay more attention to other related articles!
