Why executing MySQL query in Matlab is very slow?

8 次查看（过去 30 天）
Ashwan Autar
Ashwan Autar 2018-8-30
回答： Piyush Kumar 2024-10-23，11:27
Hi,
I am executing a MySQL query in Matlab with the lines: curs = exec(conn,sqlquery); curs1 = fetch(curs); sqlData = curs1.Data;
The table in the MySQL database has about 7 million records. What I have noticed is that Matlab writes to SQL.LOG file in the directory C:\Users\a.autar\AppData\Local\Temp. Is this the reason why Matlab is very slow? How can I solve this?
Thanks for your help.

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

回答（1 个）

Piyush Kumar
Piyush Kumar 2024-10-23，11:27
Hi,
Executing MySQL queries in MATLAB can be slow for several reasons, especially when dealing with large datasets. Here are some potential causes and solutions:
  • Large Data Volume: Fetching a large number of records (e.g., 7 million) can be inherently slow due to the volume of data being transferred and processed.
  • Indexing: Ensure that your MySQL tables are properly indexed. Indexes can significantly speed up query execution by reducing the amount of data that needs to be scanned
  • Optimizing Queries: Optimize your SQL queries to reduce the amount of data being fetched. For example, only select the columns you need and use appropriate WHERE clauses to limit the number of rows.
  • Database Configurations: Check your MySQL server configuration. Adjusting parameters like innodb_buffer_pool_size and query_cache_size can improve performance.

类别

在 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