how to optimise join queries for using with jquery datatable?

how to optimise join queries for using with jquery datatable?

CroNiX
Senior Member
Posts: 428
Threads: 0
Joined: Jan 2015
Reputation: 25

03-22-2015, 06:15 PM

Are your db tables properly indexed for the fields you are joining on, ordering by, etc? I have more joins and more rows than that on some queries that take less than a second, but they have to be properly indexed. Did you run an EXPLAIN query to see where the bottlenecks are?

Messages In This Thread

how to optimise join queries for using with jquery datatable? - by shivraj.chari - 03-22-2015, 05:07 PM

RE: how to optimise join queries for using with jquery datatable? - by CroNiX - 03-22-2015, 06:15 PM

RE: how to optimise join queries for using with jquery datatable? - by musicalangel - 03-22-2015, 09:28 PM

RE: how to optimise join queries for using with jquery datatable? - by shivraj.chari - 03-23-2015, 02:11 AM

RE: how to optimise join queries for using with jquery datatable? - by mwhitney - 03-23-2015, 07:34 AM