[OSM-dev] Stats: Report took 6043.817004 seconds to run
tom at compton.nu
Sat Sep 15 23:59:34 BST 2007
In message <b11426350709151506g684ba4e2jea31b92c3ab199ee at mail.gmail.com>
"Francisco R. Santos" <frsantos at gmail.com> wrote:
> 2007/9/15, Tom Hughes <tom at compton.nu>:
> > In message <b11426350709151117p741fdbc5te8fb86046e187940 at mail.gmail.com>
> > "Francisco R. Santos" <frsantos at gmail.com> wrote:
> > > The stats page at  says at the bottom "Report took 6043.817004seconds to
> > > run". Is this figure correct? Did it took 1:40 hours to generate one
> > single
> > > stats page? If so, I think we should disable it for the moment.
> > Yes, it probably did take that long to run.
> > Why do you think we should disable it though? Do you have some reason
> > to believe it is causing a problem?
> Mmm, right I shouldn't assume anything, but if it takes so long, I thought
> it is making some expensive queries to the database, slowing it down even
Well it table scans several large tables, but that's not a huge
problem so long as they are InnoDB tables.
Tom Hughes (tom at compton.nu)
More information about the dev