Server side processing and SQL joins
Server side processing and SQL joins
dowzer
Posts: 11Questions: 3Answers: 0
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
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
This discussion has been closed.
Replies
Allan