Huge data loading issue

vijay_bansod

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.

allan

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