Initially while loading the page the grid fetches all records then it limits?

kishorejn

Am using datatables plugin for pagination and sorting . Initially while loading the page the grid fetches all records for database then it limits the record value to 10. so page seems not responsive , in a fraction of seconds it loading so many data.please help me with this issue ?
I want to limit the no of records to 10 while initially loading . so the grid will be responsive .
example of my code :
var options = {
bsort: true,
"bFilter": false,
"sPaginationType": "full_numbers",
aoColumnDefs: [
{
aTargets: [ 0 ],
bSortable: false,
},
{
aTargets: [ 9 ],
bSortable: false,
}
]
};
$('#Table_ID').DataTable(options);

Thanks in Advance