[Babase] repstats rebuild slow

Karl O. Pinc kop at meme.com
Thu Jan 31 14:22:05 EST 2008


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



More information about the Babase mailing list