[Babase] repstats rebuild slow
kfenn
kfenn at princeton.edu
Fri Feb 1 07:46:10 EST 2008
Hi Karl,
The rebuild of REPSTATS finished by the time I came in this morning.
Total run time was:
1,568,944.266 ms
What does that mean? I want to know so I know how and when to run these
bigger programs.
Tabby
Karl O. Pinc wrote:
>
> On 01/31/2008 12:39:41 PM, kfenn wrote:
>>
>> Karl O. Pinc wrote:
>>>
>>> On 01/31/2008 09:07:38 AM, kfenn wrote:
>>>> Hi again Karl,
>>>>
>>>> I was going to rebuild repstats and members as part of the
>>>> update....I just tried repstats but it was very slow. After 10 min
>>>> I stopped it because I wasn't sure what was going on. Its a big
>>>> table...how long should I expect it to take?
>>> I'm not sure I've ever paid attention to how long it takes.
>>>
>> But does 10 minutes seem too short....should I just let it go? I
>> don't want to bog down the system with an endless query/function.
>> Nothing was moving while my computer was trying to run the rebuild.
>
> Let it run and we'll see how long it takes and what sort of impact
> it has on performance and then we'll figure out how to deal
> with it. I know I've run it while doing the conversion.
>
>
>>> CYCSTATS, REPSTATS, MDINTERVALS, MMINTERVALS
>>>
>>
>> OK, but there is no way to rebuild MDINTERVALS, MMINTERVALS right
>> now...correct? I couldn't find any programs for this in the
>> documentation and the real Babase tables are empty so I assume these
>> are still in limbo...?
>
> That's quite possible.
>
> Karl <kop at meme.com>
> Free Software: "You don't pay back, you pay forward."
> -- Robert A. Heinlein
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
--
Tabby Fenn
Research Assistant
Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ 08544
609 258-6898 (Ph)
609 258-2712 (Fx)
More information about the Babase
mailing list