Welcome Guest, Not a member yet? Register   Sign In
how to optimise join queries for using with jquery datatable?
#1
Sad 
(This post was last modified: 03-22-2015, 05:26 PM by shivraj.chari.)

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.
Reply


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



Theme © iAndrew 2016 - Forum software by © MyBB