User`s guide

6 Using Database Toolbox Functions
6-78
Property Allowable Values Description
'DefaultRowPreFetch' Input numeric
value, default
value is '10000'
Number of rows fetched from the Database
server at a time for any query. The higher
the number, the fewer the number of trips to
the server.
Caution This property is applicable only for
databases that allow setting this number,
such as Oracle.
'FetchInBatches' 'yes' or 'no'
(default)
Automates fetching in batches for large
data sets where you might run into Java
heap memory errors in MATLAB. When the
value is 'yes', fetch and runsqlscript
import the data in batches in size of
'FetchBatchSize'. For an example, see
fetch.
'FetchBatchSize' Input numeric
value, default
value is '1000'.
Supported values
are 1000 through
1000000.
Automates fetching in batches for large data
sets when used with 'FetchInBatches'.
When the value of 'FetchInBatches'
is 'yes', fetch and runsqlscript
import the data in batches in size of
'FetchBatchSize'.
For an example, see fetch. For details
about estimating a 'FetchBatchSize'
value, see “Preference Settings for Large
Data Import”.