array fetch size in JDBC connection to Vertica in Business objects 4.1 SP6
we are using Vertica 7.1 as a reporting database in our Business objects 4.1 SP6.
we have created JDBC connection to connect to the vertica database. in one of the connection parameters (Array Fetch Size) we have given value as 500. But Business objects IDT objects are giving parse error saying that the value should be less than 5.
With this low value our reports are performing very bad,
is there any restriction of the value?
if not is there any parameters we need to tune to increase the size?
What is the recommended value
Thanks for your valuable inputs.