Delayed Loading - AJAX, PHP, PDO, DataTables

tuckerm

Hi there,

I'm a little stuck at the moment regarding the speed of which I am loading one of the tables on a page for my site.

The page does load, but takes almost 20 seconds.

Below is the snippet of code I am using:

var dTable =$('#dTable_SS').DataTable( {
                    "bDeferRender": true,
                    "bFilter": true,
                "paging": true,
                "orderClasses": false,
                    "bInfo": false,
                "bSort": false,
                "bLengthChange": false,
                    "processing": true,
                "serverSide": true,
                    "ajax": "getInformation.php",
                "sScrollY": "250px",
                "columnDefs": [
                        {
                        "targets": [ 0 ],
                        "visible": false,
                        "searchable": false
                        }
                    ]
                } );

It works, but it takes so long to load that I'm worried about the database as it will get larger. Right now it only has around 6,000 entries, but the next update will see in excess of 100,000.

Can anyone provide some insight on how to speed it up?

tuckerm

Okay. I think I've figured out something. I recently upgraded to v1.10. Some of these parameters are now downgraded and are legacy. Would this hamper performance?

allan

Would this hamper performance?

No. Although I would recommend you use the current notation since that is what is documented on this site. There is a conversion document available.

Allan