Why is my database connection slower with MySQL than with Microsoft Access?

6 次查看（过去 30 天）
MathWorks Support Team
编辑： MathWorks Support Team 2021-4-30
I am inserting large amounts of data into a MySQL database. There is no problem fetching data. However my insert (both INSERT and FASTINSERT) operations are very slow. Also, the same operations are much faster with a MS Access connection. Both databases reside on the same remote location and the data that is being accessed is of similar format.

请先登录，再回答此问题。

采纳的回答

MathWorks Support Team
编辑：MathWorks Support Team 2021-4-30
MySQL tables are of type InnoDB by default. The table format InnoDB grows continually (on inserting data) and doesn't shrink when tables or data are deleted. It is recommended to use MyISAM as the table format, as this is both faster and more efficient.
The official documentation of MySQL says that InnoDB tables require a lot more disk space than MyISAM tables. Also, rollbacks take very long on InnoDB tables.
Please refer to the MySQL documentation at the following page for more information:
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by