This content has been marked as final. Show 4 replies
Hi thanks for ur reply,i have need to generate the xml files in the particular physical location for the selected records.I set the fetchsize as -1,it gets all the records but i think memory problem will be occurred in the server and at the same time it will takes much time to get the 500 records like that.Performance wise it is not good.Is any other solution for this?Please help me.
Edited by: 851924 on May 3, 2012 9:26 PM
Edited by: 851924 on May 3, 2012 9:32 PM
Edited by: 851924 on May 3, 2012 9:37 PM
for large record check the oficial doc.
PAGE_RANGING is the best option for large tables.
and these maybe will help you
Re: Performance scrolling large ADF tables
Re: Expert opinion needed: Best practices to handle huge rowsets on UI