Search code examples
grailsviewpaginationdatatableslarge-data

How to display large list in the view without using database slicing?

I have a service that generates a large map through multiple iterations and calculations from multiple tables. My problem is I cannot use pagination offset to slice the data because the data is coming from multiple tables and different modifications happen on the data. To display this on the screen; I have to send the map with 10-20,000 records to the view and that is problematic with this large dataset. At this time I have on-page pagination but this is very slow and inefficient. One thing I thought is to dump it on a table and query it each time but then I have to deal with concurrent users.

My question is what is the best approach to display this list when I cannot use database slicing (offset, max)?

I am using grails 1.0.3 datatables and jquery

Solution

  • Maybe SlickGrid! is an option for you. One of there examples works with 50000 rows and it seems to be fast.

    Christian