Do performance analysis, and find a good query block size value for the client to send to the server . Need to understand the memory usage also for greater query block size values.
DERBY-959 talks about 'Allowing use of QRYDTA block sizes greater than 32k'. As part of discussion on that jira, it was suggested that the performance analysis to decide a good query block size value for the client to send to the server be a separate task.
Here is the link to the discussion that happened for