[rt-users] My RT with #500000

[Matthew Watson]

Arh. I remember we when hit 500k tickets, oh so long ago. :)


select count(*) from tickets
  COUNT(*)
----------
   1068891
1 row selected
  
select max(id) from tickets
   MAX(ID)
----------
   1331311
1 row selected


Regards,
Matt.


> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-
> bounces at lists.bestpractical.com] On Behalf Of Lukas Maly
> Sent: Thursday, April 14, 2005 4:26 PM
> To: Rainer Duffner
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] My RT with #500000
> 
> >
> > Do you keep all 500k tickets in the database?
> >
> >
> >
> > Rainer
> >
> 
> No :-( Every month i run archive script, which get 1 years old tickets
> from db (Table Attachments is too big) and make static html.
> 
> malyl
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> RT Administrator and Developer training is coming to your town soon!
> (Boston, San Francisco, Austin, Sydney) Contact
training at bestpractical.com
> for details.
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com

This email and any files transmitted with it are confidential and intended solely for the 
use of the individual or entity to whom they are addressed. Please notify the sender 
immediately by email if you have received this email by mistake and delete this email 
from your system. Please note that any views or opinions presented in this email are solely
 those of the author and do not necessarily represent those of the organisation. 
Finally, the recipient should check this email and any attachments for the presence of 
viruses. The organisation accepts no liability for any damage caused by any virus 
transmitted by this email.