[rt-users] Purging OLD requests...

[Jesse]

Most of RT's overhead is on searching, not on updates. RT does relatively
few updates compared to the the large number of searches. 

On Thu, Oct 26, 2000 at 10:50:21AM -0700, bill at daze.net wrote:
> > MySQL gets severe indigestion if there are too many simultaneous updates. 
> > I have some serialization in front of the RT mail queues to try to avoid 
> > this, but I'm hoping to migrate to a different database engine for RT2. 
> > Aside from that, well, indexes are your friends.
> 
> I have been told by the great minds at mysql.com that the indexes are what
> slows down the updates...  since it has to rewrite the indexes at every
> update.  How to other engines handle this?
> 
> 
> _______________________________________________
> 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
-------------------------------------------------------------
"That package looks like what I wanted, but the site was down today, 
   so I decided to reimplement it in Perl."
							-me