Server Processing

boopaathykpm

Hai every one,

I was using the server processing method to retrieve the data, i have nearly 3000 records and i am loading it in datatable, when i am doing so it takes nearly 2minutes to load the data, is there any way to increase the performance of the datatable when loading the data.

I thought of doing, loading first 100 records when it loads and then load remaining records when we click on the last, whether it is possible?
please help me out

allan

2 minutes is a _very_ long time! I would have expected that a database with even a million rows would load in well under a second - but it will come down to how the server-side processing is done. I'd suggesting using YSlow or similar to see just how long the processing is taking for the XHR response, and assuming it's the script see how it might be sped up. 2 minutes for just ten rows at a time is ages!

Allan

boopaathykpm

Thanks for the reply,

Could you say how to check the XHR response, as i am new to datatable, and i'm loading data from 3 tables by checking date,time,etc , could this may be the problem of slow loading of data,

pls give me a option to overcome this problem

This is very critical

boopaathykpm

Hi Allen,

I checked the XHR response time it took 45.14s to execute the file, 4mb of data was loaded from the server processing file,

Whether i am doing any mistake in loading the data to the datatable

allan

With server-side processing, you should only need to load the data needed for each page of the table display - like this http://datatables.net/examples/data_sources/server_side.html . Have a look at the console in Firebug and you will see XHRs being passed around.

4Mb is a lot of table data - no wonder it takes a while to load!

Allan

boopaathykpm

Thanks Allan,

i tried the same method in different way now it loads much faster,

Thanks for all the replies!!!!