Server side processing and SQL joins

dowzer

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

allan

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