SQL query limits on matlab database toolbox

4 visualizaciones (últimos 30 días)
Adam
Adam el 10 de Sept. de 2013
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

Respuestas (1)

the cyclist
the cyclist el 10 de Sept. de 2013
Editada: the cyclist el 10 de Sept. de 2013
This page
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.
  4 comentarios
Adam
Adam el 10 de Sept. de 2013
I increased the Java Heap Memory on the virtual machine. Your link definitely explained the problem. Thanks for pointing that out.
the cyclist
the cyclist el 11 de Sept. de 2013
It might be nice to "accept" this answer, which may help a future user seeking similar help.

Iniciar sesión para comentar.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by