OutOfMemory errors on unlimited queries

[gunterze]

Probably caused by default behavior of PostgreSQL JDBC Driver:

By default the driver collects all the results for the query at once. This can be inconvenient for large data sets so the JDBC driver provides a means of basing a ResultSet on a database cursor and only fetching a small number of rows.

=> add Archive Device Attribute:

Name	Type	Description	LDAP Attribute
Query Fetch Size	integer	Number of rows fetched from the database at once by the Query Service. 100 if absent	dcmQueryFetchSize

[gunterze]

Fetch Size not effective for queries invoked outside of transaction => run query invoked by C-FIND service in transaction