Welcome Guest, Not a member yet? Register   Sign In
0.5s query takes 13s to run 4 times
#2

[eluser]sigsauer[/eluser]
the query is just slow... I checked with

$this->output->enable_profiler();

SELECT AVG(price) as price, week from globalhistory where product_id = 1 and week > 1098421200 GROUP BY week

this query takes 4 seconds to complete... not sure what to do now.


Messages In This Thread
0.5s query takes 13s to run 4 times - by El Forum - 08-06-2010, 12:38 AM
0.5s query takes 13s to run 4 times - by El Forum - 08-06-2010, 01:00 AM
0.5s query takes 13s to run 4 times - by El Forum - 08-06-2010, 01:51 AM
0.5s query takes 13s to run 4 times - by El Forum - 08-06-2010, 02:16 AM
0.5s query takes 13s to run 4 times - by El Forum - 08-06-2010, 03:31 AM
0.5s query takes 13s to run 4 times - by El Forum - 08-09-2010, 03:49 AM



Theme © iAndrew 2016 - Forum software by © MyBB