Server side processing and SQL joins

Server side processing and SQL joins

dowzerdowzer Posts: 11Questions: 3Answers: 0
edited January 2013 in DataTables 1.9
For the most part Datatables works great for me but on large tables (anything over 1000 rows) client side just doesn't give satisfactory performance - I have tried setting bSortClasses: false and it makes a little difference but not enough especially not as some tables are 70k rows and growing. On the 70k table it takes minutes to load the page with datatables - if I just render as an HTML table it takes a few seconds.

So I looked at server side and downloaded the example files from the site but I cannot get them to work with complex SQL queries using multiple joins - the main table I need server side for is an audit table (70k+ rows). It uses joins to do count lookups on other tables but I can't seem to add joins using server side.

Is this possible? I guess I could hack the $sQuery statement to manually add the joins but I was hoping there was a better way of achieving this?

Thanks
Jason

Replies

  • allanallan Posts: 63,389Questions: 1Answers: 10,450 Site admin
    Here is an example that does a basic join: http://datatables.net/dev/server_processing.txt . Another option is to use the Editor PHP classes which do have Join options built in.

    Allan
This discussion has been closed.