SQL query limits on matlab database toolbox

1 次查看（过去 30 天）

显示更早的评论

Adam 2013-9-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/86830-sql-query-limits-on-matlab-database-toolbox

Hello, I have an instance where I suspect Matlab might be not allowing a large SQL Select query to be processed.

Are there any settings in setdbpref or elsewhere that constrains matlab to small queries?

Thanks, AMK

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

回答（1 个）

the cyclist 2013-9-10

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/86830-sql-query-limits-on-matlab-database-toolbox#answer_96370

编辑：the cyclist 2013-9-10

This page

http://www.mathworks.com/help/database/ug/preference-settings-for-large-data-import.html

discusses Java heap memory issues with importing large query results.

I personally have not had success in processing queries in batches via the method described there. For my large queries (~millions of rows), I have needed to wrap the query in a for loop, and use SQL's "offset" and "limit" clauses to do the batching within SQL.