Page Comparison

...

Controls usage of LEFT JOINS in executed SQL statement triggered by retrieve requests.
Must be set to false, if the archive is configured as short-term cache, which delegates long-term storage to an external DICOM archive and therefore does not hold file records for each stored instance!

Default Value: false

#LazyFetchSeriesAttrsOnImageLevelQuery

Anchor
LazyFetchSeriesAttrsOnImageLevelQuery LazyFetchSeriesAttrsOnImageLevelQuery

Activates lazy fetch of Series, Study and Instance attributes stored in BLOB columns by an additional query for each series.on queries on IMAGE level.

Default Value: false

#CacheSeriesAttrsOnImageLevelQuery

Anchor
CacheSeriesAttrsOnImageLevelQuery CacheSeriesAttrsOnImageLevelQuery

Activates caching of Series attributes between IMAGE level C-FIND RSPs, which reduces the number of BLOB access from 4 x Number of matching Instances to Number of matching Instances + 3 * Number of different Series. Implicit set by #LazyFetchSeriesAttrsOnImageLevelQuery = true.

Default Value: true

#AccessBlobAsLongVarBinaryOnQuery

Anchor
AccessBlobAsLongVarBinaryOnQuery AccessBlobAsLongVarBinaryOnQuery

Change JDBC binding for Oracle BLOB's to LONGVARBINARY for accessing attributes stored in BLOB columns of DB records on query.
Only effective with Oracle as DB.

Default Value: true

#AccessSeriesBlobAsLongVarBinaryOnImageLevelQuery

Anchor
AccessSeriesBlobAsLongVarBinaryOnImageLevelQuery AccessSeriesBlobAsLongVarBinaryOnImageLevelQuery

Change JDBC binding for Oracle BLOB's to LONGVARBINARY for accessing Patient, Study and Series attributes stored in BLOB columns of DB records on query on IMAGE level. Only effective with Oracle as DB. Should only be enabled with #LazyFetchSeriesAttrsOnImageLevelQuery = true or #CacheSeriesAttrsOnImageLevelQuery = false.

Default Value: false

#LazyFetchSeriesAttrsOnRetrieve

Anchor
LazyFetchSeriesAttrsOnRetrieve LazyFetchSeriesAttrsOnRetrieve

Activates lazy fetch of Series, Study and Instance attributes stored in BLOB columns by an additional query for each series.on DICOM Retrieve and access by WADO with contentType=application/dicom.

Default Value: false

#CacheSeriesAttrsOnRetrieve

Anchor
CacheSeriesAttrsOnRetrieve CacheSeriesAttrsOnRetrieve

Activates caching of Series attributes on DICOM Retrieve, - but also for successive WADO requests for Instances of the same Series - which reduces the number of BLOB access from 4 x Number of retrieved Instances to Number of retrieved Instances + 3 * Number of different Series. Implicit set by #LazyFetchSeriesAttrsOnRetrieve = true.

Default Value: true

#CacheSeriesAttrsOnRetrieveMaxSize

Anchor
CacheSeriesAttrsOnRetrieveMaxSize CacheSeriesAttrsOnRetrieveMaxSize

Defines maximal number of Series, which attributes are cached on retrieve of Instances.
Only effective if #CacheSeriesAttrsOnRetrieve = true.

Default Value: 100

#CacheSeriesAttrsOnRetrieveCurrencyTimeLimit

Anchor
CacheSeriesAttrsOnRetrieveCurrencyTimeLimit CacheSeriesAttrsOnRetrieveCurrencyTimeLimit

Defines how long cached Series Attributes on retrieve are valid.
Format: ##s (in seconds), ##m (in minutes)
Only effective if #CacheSeriesAttrsOnRetrieve = true

Default Value: 1m

#AccessBlobAsLongVarBinaryOnRetrieve

Anchor
AccessBlobAsLongVarBinaryOnRetrieve AccessBlobAsLongVarBinaryOnRetrieve

Change JDBC binding for Oracle BLOB's to LONGVARBINARY for accessing attributes stored in BLOB columns of DB records on retrieve.
Only effective with Oracle as DB.

Default Value: true

#AccessSeriesBlobAsLongVarBinaryOnRetrieve

Anchor
AccessSeriesBlobAsLongVarBinaryOnRetrieve AccessSeriesBlobAsLongVarBinaryOnRetrieve

Change JDBC binding for Oracle BLOB's to LONGVARBINARY for accessing Patient, Study and Series attributes stored in BLOB columns of DB records on retrieve. Only effective with Oracle as DB. Should only be enabled with #LazyFetchSeriesAttrsOnRetrieve = true or #CacheSeriesAttrsOnRetrieve = false.

#QueryTransactionIsolationLevel

Anchor
QueryTransactionIsolationLevel QueryTransactionIsolationLevel

...