[rt-users] Postgres vs Mysql, rt2 vs rt3?

Reini Urban rurban at inode.at
Wed May 21 10:34:22 EDT 2003


Seth Cohn, EFN General Manager wrote:
> The problem right now is tons of local complaints about how slow the
> ticket system is... (and the resulting reluctance to use it)

yes.

> running 2.0.15 with many tweaks (including enhanced mailgate) with a
> postgres backend, on a dedicated 600mhz box... (yes, I'd love to beef that
> box up...)
> 
> I'd like to eventually migrate to rt3, once things like mailgate are
> working for it... but can't until then.
> 
> Will moving to Mysql on rt2 speed things up?  Reading the mailing lists 
> over the recent months make it appear so, but I'm looking for
> confirmation.  Also, is there a good/better way to dump and then restore
> the db, going from postgres to mysql?

mysql 4 with innodb for the rt tables should be the fastest.
-- 
Reini Urban - Programmer - http://inode.at




More information about the rt-users mailing list