[imp] MySQL performance tuning.

Chuck Hagenbuch chuck@horde.org
Sat, 31 Aug 2002 17:56:35 -0400


Quoting Shawn Robinson <Shawn.Robinson@telus.com>:

> Add an index on turba_objects object_owner.  If you have lots of users
> searching the address book, it's killer to do a table scan even if it's
> cached. We've got about 500K addressbook entries, and the index was 
> necessary at around 150K.

I'd love to hear more things like that that we can add to the db scripts to
improve performance. I'll commit this one to the turba scripts in a minute,
and will gladly add more.

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
"After a few minutes the most aromatic and nice smelling Italian coffee 
 will come out of the exhaustpipe." - Our stove-top espresso pot