Ok so the script is done. It took a bit longer than I had expected,
but when it finished then things sped back up ('24 hours' of data in 6
sec). There are a few more maintenance operations I want to run which
will help out a bit more, but I'll push those to this weekend.
Thanks for your
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
