How should I handle huge data as it takes toooooo much time to load.

sadia_Khan

Hi all
I am using datatables for listing its working fine but when there is huge amount of data it takes too much time to load the list even I have waited for 10-15 mins but its dont show list just loading loading and loading,

Kindly help me to fix it as my db have more then 50,000 records which i have to show in the list guide me how i could???



$(document).ready(function () {
$('#tblMyTankList').dataTable({
"bJQueryUI": true
, "bSort": true
, "sScrollY": 200,
"sScrollX": "100%",
"sScrollY": "100%",
"sScrollYInner": "200%"
}).makeEditable({
"sDeleteURL": '@Url.Action("DeleteTank", "MyController")',
'sAddDeleteToolbarSelector': '.dataTables_length'

});
});





thanks

allan

See the FAQs: http://datatables.net/faqs#speed

Allan

sadia_Khan

allan thanx for your response.
I am unable to understand to use AJAXSource.what is "sources/arrays.txt", in

"sAjaxSource": "sources/arrays.txt",
"bDeferRender": true

is it the url to get records from db or what?can you please explain it to me. :(

allan

> is it the url to get records from db or what?

Yes - it is the records from the database. See also: http://datatables.net/blog/Extended_data_source_options_with_DataTables

Allan