MATLAB DATABASE TOOLBOX RELEASE NOTES Guía de usuario descargar pdf (Pagina 420)

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”.

1 2 ... 415 416 417 418 419 420 421 422 423 424 425 ... 683 684

Comentarios a estos manuales

Sin comentarios