[rt-users] Database size management

[Kenneth Marshall]

Calvin,

We keep everything. Even at 25MB/week, that is only 1.3GB/year
which means a standard 146GB drive will last a bit over a century.
That is a bit tongue-in-cheek, but really this data volume is
easily managed by small laptops and PDAs. You can use the shredder
function to delete tickets after a certain period to free up space.
We have zeroed out some large attachments that people attached to
a ticket (100+MB) otherwise we just let it be. Bringing them back
online is not particularly easy since the entire app was built with
historical accuracy and permanence in mind.

Cheers,
Ken

On Mon, Jan 19, 2009 at 05:44:34PM +0000, Calvin Chiang wrote:
> Hi All,
> 
> I've got a RT 3.6 install. Approx 20 users, and a database size of about 
> 500MB.
> It looks like i'm adding 25MB of data per week.. so it's growing quite a 
> bit faster than i'd like.
> 
> Any recommendations for data that i should look at stripping out of the 
> database? or do people archive their databases? if you do is it pretty 
> easy to bring them back online again if need be?
> 
> Cheers,
> 
> -- 
> Calvin Chiang
> Network Admin
> Utilyx
> 1st Floor, 55 North Wharf Road
> Paddington
> London, W2 1LA
> Tel: 020 7087 8673
> www.utilyx.com
> 
> 
> ______________________________________________________________________
> "Utilyx" is the trading name of "Utilyx Limited" and "Utilyx Risk Management Limited" (URML). URML is authorised and regulated by the Financial Services Authority (FSA). This message contains information that may be privileged or confidential and is the property of Utilyx. It is intended only for the person to whom it is addressed. No confidentiality or privilege is waived or lost by any mistransmission. Any views or opinions expressed in this message are solely those of the author and do not necessarily represent those of Utilyx. Unless otherwise stated, any pricing information given in this message is indicative only and does not constitute an offer to deal at any price quoted. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email 
> ______________________________________________________________________
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>