[imp] MySQL performance tuning.

[Christopher Crowley]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Shawn -

Thanks.  I added the index, and it looks better already. I will have
to wait again for the real heavy load time tomorrow, but I expect
that index to make a significant improvement.  We are at 80K records
in turba_objects.  What hardware are you running on? 

Christopher Crowley
TIS Network Services
Tulane University
ccrowley@tulane.edu
504.314.2535
PGP Key ID: 0x7CF18FDB


- ----- Original Message ----- 
From: "Shawn Robinson" <Shawn.Robinson@telus.com>
To: "Christopher Crowley" <ccrowley@tulane.edu>;
<imp@lists.horde.org>
Sent: Wednesday, August 28, 2002 3:57 PM
Subject: Re: [imp] MySQL performance tuning.


> 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.
> 
> Regards,
> Shawn

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>

iQA/AwUBPW1CxM0q7cR88Y/bEQLjcQCgppTvSQNUyzEutJD8fbF53p3AcpoAn2DS
jJX5+b9lK44/3WpWG8lungaV
=zDnT
-----END PGP SIGNATURE-----