Importance of Array Fetch Size in Connection parameters..
I would like to tell you something the importance of the Array Fetch Size.
While establishing a connection to database, we need to fill some parameters, array fetch size is one of that.
Array Fetch Size defines the no.of record to be extracted during every fetch.
if your record is supposed to fetch 5000 records and array fetch size set to 100.the BO will connect to database 50 times to retrieve 100 records in each fetch.
B.O fetched data from database in following steps:
1) Connect to Database
3)Retrieve data from database and submit it to webi server for processing.
Considering above example, Bo will repeat above steps for 50 times to get 5000 records which is definitely performance degrading.
so Based upon possibilities you just give higher values to Array Fetch Size.
if net work allows large arrays then set high Array Fetch Size.
Limitations: before setting up higher Array Fetch Size values make sure that you have adequate memory on client side to process large result set..
Thanks & Regards