Hi,
I have settings on DataDirect 4.1 32Bit Progress SQL92 v9.1D driver as read uncommitted and a fetch array size of 500 rows. I do find we have delays in getting data back and I would like your opinion please on whether this fetch array size can comfortably increase to 2000 or more. Will this provide a noticable performance increase when using the driver via Crystal Reports / Crystal Enterprise or could it have an opposite effect? What are the finite limits for array size and are they determined by the Progress database size/complexity.
Thanks.
Gary. :lol:
I have settings on DataDirect 4.1 32Bit Progress SQL92 v9.1D driver as read uncommitted and a fetch array size of 500 rows. I do find we have delays in getting data back and I would like your opinion please on whether this fetch array size can comfortably increase to 2000 or more. Will this provide a noticable performance increase when using the driver via Crystal Reports / Crystal Enterprise or could it have an opposite effect? What are the finite limits for array size and are they determined by the Progress database size/complexity.
Thanks.
Gary. :lol: