I am using a jquery datatable to display records. I am fetching around 12000 records from database and appending it to html table and then converting it to jQuery datatable.
The conversion to datatable takes a very long time. I waited for around 15mins but still the table is not loaded.
Any ideas how to solve it?
pagination and displaying only few records at a time, have a look at: http://datatables.net/plug-ins/pagination. Displaying 12000 record at once, I don't this really provides good user experience. Use ajax and pagination to load your data for each page.