Too many ajax request
Too many ajax request
fboland
Posts: 18Questions: 0Answers: 0
Hi,
I'm trying to run datatable in server side processing mode with scroller like in this example : http://datatables.net/release-datatables/extras/Scroller/server-side_processing.html
Here is my code :
[code]
$(document).ready(function()
{
$('.datatable1').dataTable(
{
"sScrollY": "500px",
"sAjaxSource": "TestDataTableAjax1.php",
"bServerSide": true,
"sDom": "frtiS",
"oScroller": { "loadingIndicator": true }
});
});
[/code]
The problem is that when i scroll slowly, i realize that several ajax request are done instead of one.
For one mouse wheel, all these request are done :
[code]
http://web.toto.com/TestDataTableAjax1.php?sEcho=2&iColumns=2&sColumns=&iDisplayStart=12&iDisplayLength=189&mDataProp_0=0&mDataProp_1=1&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&_=1386231889586
http://web.toto.com/TestDataTableAjax1.php?sEcho=4&iColumns=2&sColumns=&iDisplayStart=36&iDisplayLength=189&mDataProp_0=0&mDataProp_1=1&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&_=1386231889588
http://web.toto.com/TestDataTableAjax1.php?sEcho=3&iColumns=2&sColumns=&iDisplayStart=20&iDisplayLength=189&mDataProp_0=0&mDataProp_1=1&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&_=1386231889587
http://web.toto.com/TestDataTableAjax1.php?sEcho=5&iColumns=2&sColumns=&iDisplayStart=50&iDisplayLength=189&mDataProp_0=0&mDataProp_1=1&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&_=1386231889589
http://web.toto.com/TestDataTableAjax1.php?sEcho=7&iColumns=2&sColumns=&iDisplayStart=66&iDisplayLength=189&mDataProp_0=0&mDataProp_1=1&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&_=1386231889591
http://web.toto.com/TestDataTableAjax1.php?sEcho=6&iColumns=2&sColumns=&iDisplayStart=58&iDisplayLength=189&mDataProp_0=0&mDataProp_1=1&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&_=1386231889590
[/code]
In the example (http://datatables.net/release-datatables/extras/Scroller/server-side_processing.html) only 2 are done :
[code]
http://datatables.net/release-datatables/extras/Scroller/media/data/server_processing.php?sEcho=2&iColumns=5&sColumns=&iDisplayStart=2&iDisplayLength=81&mDataProp_0=0&mDataProp_1=1&mDataProp_2=2&mDataProp_3=3&mDataProp_4=4&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&sSearch_2=&bRegex_2=false&bSearchable_2=true&sSearch_3=&bRegex_3=false&bSearchable_3=true&sSearch_4=&bRegex_4=false&bSearchable_4=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&bSortable_2=true&bSortable_3=true&bSortable_4=true&_=1386232219852
http://datatables.net/release-datatables/extras/Scroller/media/data/server_processing.php?sEcho=3&iColumns=5&sColumns=&iDisplayStart=22&iDisplayLength=81&mDataProp_0=0&mDataProp_1=1&mDataProp_2=2&mDataProp_3=3&mDataProp_4=4&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&sSearch_2=&bRegex_2=false&bSearchable_2=true&sSearch_3=&bRegex_3=false&bSearchable_3=true&sSearch_4=&bRegex_4=false&bSearchable_4=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&bSortable_2=true&bSortable_3=true&bSortable_4=true&_=1386232222426
[/code]
Is it normal ? How is it manage ?
Thx
I'm trying to run datatable in server side processing mode with scroller like in this example : http://datatables.net/release-datatables/extras/Scroller/server-side_processing.html
Here is my code :
[code]
$(document).ready(function()
{
$('.datatable1').dataTable(
{
"sScrollY": "500px",
"sAjaxSource": "TestDataTableAjax1.php",
"bServerSide": true,
"sDom": "frtiS",
"oScroller": { "loadingIndicator": true }
});
});
[/code]
The problem is that when i scroll slowly, i realize that several ajax request are done instead of one.
For one mouse wheel, all these request are done :
[code]
http://web.toto.com/TestDataTableAjax1.php?sEcho=2&iColumns=2&sColumns=&iDisplayStart=12&iDisplayLength=189&mDataProp_0=0&mDataProp_1=1&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&_=1386231889586
http://web.toto.com/TestDataTableAjax1.php?sEcho=4&iColumns=2&sColumns=&iDisplayStart=36&iDisplayLength=189&mDataProp_0=0&mDataProp_1=1&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&_=1386231889588
http://web.toto.com/TestDataTableAjax1.php?sEcho=3&iColumns=2&sColumns=&iDisplayStart=20&iDisplayLength=189&mDataProp_0=0&mDataProp_1=1&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&_=1386231889587
http://web.toto.com/TestDataTableAjax1.php?sEcho=5&iColumns=2&sColumns=&iDisplayStart=50&iDisplayLength=189&mDataProp_0=0&mDataProp_1=1&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&_=1386231889589
http://web.toto.com/TestDataTableAjax1.php?sEcho=7&iColumns=2&sColumns=&iDisplayStart=66&iDisplayLength=189&mDataProp_0=0&mDataProp_1=1&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&_=1386231889591
http://web.toto.com/TestDataTableAjax1.php?sEcho=6&iColumns=2&sColumns=&iDisplayStart=58&iDisplayLength=189&mDataProp_0=0&mDataProp_1=1&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&_=1386231889590
[/code]
In the example (http://datatables.net/release-datatables/extras/Scroller/server-side_processing.html) only 2 are done :
[code]
http://datatables.net/release-datatables/extras/Scroller/media/data/server_processing.php?sEcho=2&iColumns=5&sColumns=&iDisplayStart=2&iDisplayLength=81&mDataProp_0=0&mDataProp_1=1&mDataProp_2=2&mDataProp_3=3&mDataProp_4=4&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&sSearch_2=&bRegex_2=false&bSearchable_2=true&sSearch_3=&bRegex_3=false&bSearchable_3=true&sSearch_4=&bRegex_4=false&bSearchable_4=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&bSortable_2=true&bSortable_3=true&bSortable_4=true&_=1386232219852
http://datatables.net/release-datatables/extras/Scroller/media/data/server_processing.php?sEcho=3&iColumns=5&sColumns=&iDisplayStart=22&iDisplayLength=81&mDataProp_0=0&mDataProp_1=1&mDataProp_2=2&mDataProp_3=3&mDataProp_4=4&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&sSearch_2=&bRegex_2=false&bSearchable_2=true&sSearch_3=&bRegex_3=false&bSearchable_3=true&sSearch_4=&bRegex_4=false&bSearchable_4=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&bSortable_2=true&bSortable_3=true&bSortable_4=true&_=1386232222426
[/code]
Is it normal ? How is it manage ?
Thx
This discussion has been closed.
Replies
Allan
Allan
It is online : http://lerelaisimmobilier.com/TestDataTable.php