[rt-users] Purging OLD requests...

[Jesse]

On Wed, Oct 25, 2000 at 11:19:55PM -0600, Jill Lundquist wrote:
> 
> >As far as I know, nobody's eve3r written the RT data warehousing tool which 
> >would take old requests and transactions and move them to an archival database.
> >
> >Basically, you want to make sure you yank both tickets and transactions.  If
> >this is merely a performance issue, there may be other ways to deal. (Column indexes, etc.)
> 
> Is the warehousing tool feasible in your opinion?  Is it the right way to
> do it?

The warehousing tool is certainly feasable. Essentially it would move 
all the old transactions and tickets (using local criteria for the meaning of "old")
to a seperate database which was intended for reports, data mining and archival use.
I've never written the tool because I've never been anywhere with an RT instance 
that was to big or slow for easy use.

        Jesse


> It seems to me that an innate weakness of the system is that it would always
> get bigger, and that it would be impossible to run a queue with any kind of
> turnover for more than n years before having to start over.  Some way to
> warehouse the old transactions would be very useful after a long time 
> running, or a shorter time with a very busy queue.  
> 
>              Jill
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

-- 
jesse reed vincent --- root at eruditorum.org --- jesse at fsck.com 
pgp keyprint: 50 41 9C 03 D0 BC BC C8 2C B9 77 26 6F E1 EB 91
-------------------------------------------------------------
Any e-mail sent to the SLA will immediately become the intellectual property
of the SLA and the author of said message will enter into a period of
indentured servitude which will last for a period of time no less than seven
years.