I'm seeing between 12 and 20 seconds on a fairly idle machine. We can
likely do better. I'll dig into it this week[end] and see what I can do.
12 - 20 isn't too bad though considering the amount of data that query
is returning. :)
On Jan 30, 2008, at 2:52 PM, Ethan Mallove wrote:
I don't remember a "past 24 hour" summary taking "24
seconds". Are we seeing a slow down due to an accumulation
of results? I thought the week-long table partitions would
prevent this type of effect?
-Ethan
On Wed, Jan/30/2008 11:00:46AM, Josh Hursey wrote:
This maintenance is complete. The reporter should be operating as
normal.
There are a few other maintenance items, but I am pushing them to the
weekend since it will result in a bit of a slowdown again.
Thanks for your patience.
Cheers,
Josh
On Jan 29, 2008, at 9:47 AM, Josh Hursey wrote:
The reporter should be responding much better now. I tweaked the
maintenance scripts so they no longer push nearly as hard on the
database. They are still running, but the query you specified
seems to
run in approx. 15-20 sec. with the current load.
-- Josh
On Jan 29, 2008, at 8:38 AM, Josh Hursey wrote:
For the next 24 - 48 hours this is to be expected. Sorry :(
I started some maintenance work last night, and it is taking a bit
longer than I expected (due to integrity constraint checking most
likely). The maintenance scripts are pushing fairly hard on the
database, so I would expect some slowdown with the reporter (and
maybe
client submits).
If this becomes a substantial problem for anyone please let me
know,
and I may be able to shift this work to the weekend. In the mean
time
I'll see if I can reduce the load a bit.
-- Josh
On Jan 29, 2008, at 7:44 AM, Tim Prins wrote:
Hi,
Using the reporter this morning it is being awfully slow, as in it
is
taking about 3 minutes to do a top level summary search for:
Date: past 24 hours
Org: IU
Platform name: IU_Odin
I don't know whether this is a known problem or not. I seem to
recall
that after the last database upgrade such a search was taking
just a
few
seconds.
Thanks,
Tim
_______________________________________________
mtt-users mailing list
mtt-us...@open-mpi.org
http://www.open-mpi.org/mailman/listinfo.cgi/mtt-users
_______________________________________________
mtt-users mailing list
mtt-us...@open-mpi.org
http://www.open-mpi.org/mailman/listinfo.cgi/mtt-users
_______________________________________________
mtt-users mailing list
mtt-us...@open-mpi.org
http://www.open-mpi.org/mailman/listinfo.cgi/mtt-users
_______________________________________________
mtt-users mailing list
mtt-us...@open-mpi.org
http://www.open-mpi.org/mailman/listinfo.cgi/mtt-users
_______________________________________________
mtt-users mailing list
mtt-us...@open-mpi.org
http://www.open-mpi.org/mailman/listinfo.cgi/mtt-users
