The data misplacement is now fixed.
Over the past 2 days I have been moving the data that was accidentally
put in the master partition tables into their correct date partition
tables. I still need to clean up test_run, but I am pushing that to
this weekend since it will slow down the databa
It seems the reporter has gotten slower :( Now it is working in the
range of 40 - 50 seconds for the 24 hour query which is not
reasonable. This should be much lower.
Looking at the explain of the query I have some ideas on how to make
things better, but this will slow things down a for a w
I'd go ahead and do it now.
On Jan 30, 2008, at 4:04 PM, Josh Hursey wrote:
It seems the reporter has gotten slower :( Now it is working in the
range of 40 - 50 seconds for the 24 hour query which is not
reasonable. This should be much lower.
Looking at the explain of the query I have some ide
I've started the script running.
Below is a short version, and a trilogy of the gory details. I wanted
to write up the details so if it ever happens again to us (or someone
else) they can see what we did to fix it.
The Short Version:
--
The Slowness(tm) was caused by the re
