[horde] Horde Implementation Going South

Andrew Morgan morgan at orst.edu
Wed Sep 5 23:58:20 UTC 2007


On Wed, 5 Sep 2007, Dave Cunningham wrote:

>
> I have confirmed that many of my slow queries do make use of indexes, 
> but that many also do not.  I'm not really sure how to proceed to do 
> something about this.  Many of them appear to be general select commands 
> on address books.

Make sure you run ANALYZE TABLE on all the Horde tables before you trust 
the output of EXPLAIN.

The Horde install scripts should have already created the necessary 
indices, but if you do find un-indexed queries please post them.

 	Andy


More information about the horde mailing list