[p4] HELP!!!

[Venters, Cheryl]

We're using 2005.2 on sunos 5.9. Our performance has been pretty bad. At
certain times of the day, you can watch the little feet walk for five
minutes on a simple p4 changes command (narrowed to a specified
directory). We were originally planning to just move the db files over
to the new location however, given the input I've received, I'm glad I
did the restore from checkpoint. Hopefully everyone will see an
improvement.

Thanks.
Cheryl
-----Original Message-----
From: Robert Cowham [mailto:robert at vaccaperna.co.uk] 
Sent: Sunday, October 22, 2006 12:04 PM
To: Venters, Cheryl; 'Jeff Grills'; perforce-user at perforce.com
Subject: RE: [p4] HELP!!!

You should be fine as Jeff says. Db.* being quite a bit smaller is quite
normal for restores after checkpoints. If you look at the journal file,
the
only entry you are likely to find is that the journal counter has been
bumped.

Out of interest, what server version are you on?

Also, if performance is an issue, what OS/hardware platform are you on?

Regards
Robert 

> -----Original Message-----
> From: perforce-user-bounces at perforce.com 
> [mailto:perforce-user-bounces at perforce.com] On Behalf Of 
> Venters, Cheryl
> Sent: 22 October 2006 07:32
> To: Jeff Grills; perforce-user at perforce.com
> Subject: Re: [p4] HELP!!!
> 
> We had originally planned to just move the db files but our 
> performance was so bad and our db files so large we thought 
> it would be good to do it all at one time. I looked at some 
> of the files that were checked in a couple of hours before I 
> made the final checkpoint and they seemed to be fine so I 
> think it's okay. I just wanted to double check.
> 
> Thanks.
> Cheryl
> -----Original Message-----
> From: Jeff Grills [mailto:jgrills at drivensnow.org]
> Sent: Saturday, October 21, 2006 11:26 PM
> To: Venters, Cheryl; perforce-user at perforce.com
> Subject: RE: [p4] HELP!!!
> 
> You may not have done anything wrong.  Restoring from a 
> checkpoint can reduce DB file sizes, and in doing so it can 
> also improve performance of your server as well.  I'm 
> surprised that perforce support wouldn't have had you try 
> rebalancing before moving the files.  And by the way, if you 
> weren't changing system architectures, you could have just 
> copied your DB files instead of restoring from the 
> checkpoint.  The bad news is that you've changed two 
> variables at one time, so it's going to be difficult to know 
> whether the local files or the DB rebalancing caused any 
> performance changes you notice.
> 
> See http://tinyurl.com/y7r69e or
> http://www.perforce.com/perforce/doc.061/manuals/p4sag/07_perf
tune.html#
> 1055
> 420 for details about "checkpoints for database tree rebalancing".