why is the result of my fetch not complete in database?

5 visualizaciones (últimos 30 días)
Aubai
Aubai el 29 de Nov. de 2016
Comentada: Aubai el 17 de En. de 2017
I am trying to load some data from a database using matlab. for that i have written my SQL-query and connected to my database and so on.
when asking for the number of raws obtained from the selected search SQL-Query (Using the SELECT COUNT(*) query) i am getting num_rows = 63591 which is correct and i do expect. yet when afterword i use the 'exec-function' to the same SQL-search query, followed by the 'fetch-function' i am not getting the expected number of rows given by num_raws.
can anyone help me out here? what am I doning wrong?
Best Regards
  2 comentarios
Sanjana Ramakrishnan
Sanjana Ramakrishnan el 12 de Dic. de 2016
Since the size of the dataset is huge, 'fetch' command may not have retrieved all the rows. This can be resolved by setting database preferences, to fetch large dataset as below:
1. Execute the below automate fetching in batches for large datasets: >>setdbprefs('FetchInBatches','yes')
2. Execute the below command to import data in batches of size '1000' >>setdbprefs('FetchInBatches','1000')
The above commands would enable importing of large datasets in batches of 1000.
Please refer the below links for more information
Aubai
Aubai el 17 de En. de 2017
Thx Very much that did help and sorry for the late replay.

Iniciar sesión para comentar.

Respuestas (0)

Etiquetas

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by