How to handle a database connection (mysql) in loops (for and parfor)?

Question

Léon 2013-6-1

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/77670-how-to-handle-a-database-connection-mysql-in-loops-for-and-parfor

评论： TIANTIANBABA 2021-1-17

Hello,

I already got a working code that does exactly this (see below). But I have to big problem that it is too slow. So I want to use that in parfor to speed it up and would be happy if you can give me hint of how to write the code using for parfor, many thanks.

%%"for-loop" version
db       = 'my_database';
user     = 'matlab';
password = '1234';
host     = '100.200.300.4';
conn = database(db, user, password,'com.mysql.jdbc.Driver',['jdbc:mysql://' host ':3306/' db]);          
setdbprefs('DataReturnFormat','cellarray');
for i = 1:1000
SQL = ['SELECT * FROM `my_table`;'];
e = exec(conn,SQL);
e = fetch(e);
data = e.Data;
end
close(conn)