Our customer wants to implement a listing screen. Customer wants to show 10 records per page
Screen will have :: Event NameEvent LocationEvent Start Date
From customer perspective this is what he wants :: Show 10 records per page Ability to sort on any of the three fields Default sort should be on "Event Name " asc Sorting should toggle - i.e if data is sorted "asc" and the "event name " is clicked - then it should sort "desc"
My query :: The number of events that will turn up is typically into thousands of records .
1 > Storing that many records in memory will not be a good idea So should I retrieve only the first ten records ? ( If user clicks on "Next" in pagination link - then retrieve the next set of ten records )
2 > Assuming this is correct way to go ? The SQL query would need to consider the rowId ?
3 > Sorting - When user clicks on the title link - sorting should happen Should we just sortfor the records for that page ?
Should we get all the records sorted from the database again and then display the results ? ( For question 3 - can negotiate and change the requirement depending on what is feasible )
4 > Is it possible to sort data for multibyte characters ? ( Requirement states that Event Name can be entered in Multibyte - Chinese / Japansese )
In Java / Oracle is there any way that this can be done ?
Hi Satish, Pagination of bulk data is better when fetched based on on-demand quantity.One can then manipulate(Sort) the same quantity fetched.One should keep track of rowId/limit in-use to meet next fetch based on total rows. Hit me back if am wrong.