[Babase] repstats rebuild slow

kfenn kfenn at princeton.edu
Thu Jan 31 13:39:41 EST 2008


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.

>>
>> Are there any other tables you think I should rebuild as a standard 
>> part of the update?
>
> All of the tables listed in the section "The Reproductive
> State Tables", except for CYCGAPDAYS.
>
> 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...?

Tabby
> _______________________________________________
> 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