how to optimise join queries for using with jquery datatable? |
hello
i am using jquery datatable for my project ,which is developed in codeigniter.I am using server side processing for datatable using ajax.To display data it is doing 4 table join queries.each table has 12k records.but when i run the query it takes lotsa time to display the result and the server eventually timeouts. I am using Ignited Datatables wrapper for using data table with codeigniter. any help will be appreciated thanks in advance. |
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
|