Hi Team,
JDev Version 11.1.1.7
I have a scenario we have a search page in which the table has more than 1 lacs records. For Tuning we have customize the fetch size at VO level and Iterator at the page destination for the page to make the performance faster at the time of loading the records in UI.
We have an export functionality implemented using apache POI as export action listener has limitation of 65K record in an excel.
Issue : Because of the range size , for eg if range size of VO iterator=50, When i am iterating through the records to export it into excel after 50 records ie 51st ..52nd...records the fetching becomes very slow.
I was trying to export 20k records of ADF table, it took around 45 minutes to download the file. But still the downloaded file contained only 7k records. I cannot set the range size for the iterator =-1 as it will impact the search functionality in loading the records.
Any Suggestion / Any clarification required ..please let me know asap.
Thanks
Abhishek