[rt-users] *very* slow 'OR' searches

[Jesse Vincent]

> I found a post to the MySQL MaxDB mailing list from someone running RT
> on MaxDB, complaining about the performance of ORs, with a response
> from someone at SAP that this is a hard problem, and MaxDB currently
> does not optimize ORs--that saved me from trying MaxDB.  I _could_
> try Oracle, but it's probably easier to tell our users not to OR
> dissimilar types.

Rather than trying other databases, It makes more sense to spend a bit
of time on RT::Tickets_Overlay.pm's logic ;)  Patches are most certainly
welcome.

> 
> -dan
> _______________________________________________
> 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
> 

--