[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