[p4] How big is too big? - Russell C. Jackson - com.perforce.perforce-user

3 messages in com.perforce.perforce-user[p4] How big is too big?

From	Sent On	Attachments
David Ferguson	05 Aug 2004 17:57
Russell C. Jackson	05 Aug 2004 18:45
Ivey, William	06 Aug 2004 08:14

Subject:	[p4] How big is too big?
From:	Russell C. Jackson (rcja...@high-tech-homes.com)
Date:	08/05/2004 06:45:51 PM
List:	com.perforce.perforce-user

Are you having performance issues? I have worked on systems that have larger files than that, and are not having problems. The biggest problem with the ever increasing file sizes are trying to do obliterates. I gave up on doing those on one installation.

There are things you can do to reduce the size of those files without losing data. You can output labels and clients to text files and store them in the server, and delete them out of the metadata. They can be restored if they are ever needed again. Doing that on a regular basis helps to reduce the size of some of the files, but not all of them.

Rusty

-----Original Message----- From: perf...@perforce.com [mailto:perforce-user-admin at perforce.com] On Behalf Of David Ferguson Sent: Thursday, August 05, 2004 5:58 PM To: perforce-user at perforce.com Subject: [p4] How big is too big?

Just a quick query to see how big people's databases can get and whether mine is as out-of-whack as I suspect. Do people think the numbers below are normal, excessive, or downright scary?

db.have : 11.3G db.integed: 2.2G db.rev: 1.4G

I'm strongly suspicious that I have people with too many clients that are too large... FWIW, 270 users 2800 clients

I rebuild the database approximately monthly to try and keep the checkpoint process down to less than an hour (it runs 900Meg compressed) We'll be upgrading from 2002.1 --> 2003.2 next week.

What do you think? Time to break up the depot?

-daf