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

[eluser]sigsauer[/eluser]
It's using MyISAM. The table has 7.5 million records. It's running on Rackspace Cloud's Cloud Site product.

All I can think of is on "group by" optimizations and on the indexes.

Should the engine play a big role on this query?


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