SQL Database - Import Specific Rows from Large file

조회 수: 1 (최근 30일)
Hayden Raabe-Garmon
Hayden Raabe-Garmon 2023년 3월 16일
답변: Srija Kethiri 2023년 4월 18일
Hello!
I am dealing with some fairly large SQL Database Tables, some that can take multiple minutes to fetch/read. Is there a way to import select rows from the table to decrease processing time? This processing time extendings the loading time for an app that I am designing.
(Parralell Computing Toolbox is not an option)

채택된 답변

Srija Kethiri
Srija Kethiri 2023년 4월 18일
Hi Hayden,
I understand that you have a large database and want to import only a few rows from it, to decrease the processing time.
You can use the “databaseImportOptions” function and set the “RowFilter” property of the function, to the desired condition to import the data you required.
To know more about “databaseImportOptions”, please refer to the following documentation:
Hope this helps!

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Database Toolbox에 대해 자세히 알아보기

제품


릴리스

R2023a

Community Treasure Hunt

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

Start Hunting!

Translated by