Hi,
I have tried to read 3,00,000 records. I was able to do this.
Please advise. Is any other way to perform this.
Thanks,
Vinod
I don't know if you followed an other identical thread but my observations are:
1) users are not willing to scroll through so much data. They want it in reasonable
chunks through which they can navigate.
2) you can't collect that much database because of memory constraints.
So my tip is to 'page' through all the data. Depending on your database and its
SQL dialect you might check the 'offset/limit' statement parts or the 'numrows'
statement part or whatever your database supports.
A few buttons for navigational purposes and just a bit of data in the Session
object can do the rest. Don't try to retrieve and show all the data in one piece.
kind regards,
Jos