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

[Jay R. Ashworth]

On Sun, Apr 03, 2005 at 12:25:43PM -0600, Michael Loftis wrote:
> > I find it somewhat worrisome that it is so easy to stumble across a
> > simple search that takes essentially forever.  Presumably this happens
> > because neither the query builder nor the MySQL "optimizer" notices
> 
> MySQL doesn't have an optimizer, at all.  Basically it takes a best guess 
> based on query term ordering and available indices.  It's reliable and 
> predictable but the programmer (or in this cas search builder) has to do 
> all the real work.

Sounds like another good reason to use PgSQL instead.  :-)

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Designer                          Baylink                             RFC 2100
Ashworth & Associates        The Things I Think                        '87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727 647 1274

      If you can read this... thank a system administrator.  Or two.  --me