Huge data loading issue

Huge data loading issue

vijay_bansodvijay_bansod Posts: 1Questions: 0Answers: 0
edited April 2013 in DataTables 1.9
I am using DataTables 1.9 with server side processing for getting data from database. I have lot(around 33) of joins in SQL query because of that page loads too slow. Database is structure is too complicated to get data on that page, I am using Cake PHP for development. Can any one please suggest how to improve performance in such conditions.

Thanks in Advance.

Replies

  • allanallan Posts: 63,386Questions: 1Answers: 10,449 Site admin
    It sounds like the complexity is all in your server-side code. As such, we can't offer any suggestions on how to improve performance as we have no idea what that code looks like. This is also not the correct forum to ask help about server-side code. Try Stack Overflow with a specific question about how to improve your SQL.

    Allan
This discussion has been closed.