[Tickets #6633] Re: Performance query MYSQL

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/6633
-----------------------------------------------------------------------
 Ticket             | 6633
 Updated By         | Michael Rubinsky <mrubinsk at horde.org>
 Summary            | Performance query MYSQL
 Queue              | Kronolith
 Version            | HEAD
 Type               | Bug
 State              | Unconfirmed
 Priority           | 1. Low
 Milestone          |
 Patch              |
 Owners             |
-----------------------------------------------------------------------


Michael Rubinsky <mrubinsk at horde.org> (2008-04-22 07:55) wrote:

> I created an index on the table horde_datatree_attributes on
attribute_value.
> My problem seems resolved (I hope).

This index has been in CVS code since 9/30/07...along with other added
indexes. You should check the scripts/upgrades directory for any others you
may have missed.

On a related note, if your feeling adventuresome, there is a new share
driver that does away with the datatree completely. It's currently
considered 'beta' status, but is available for testing in the latest Horde
CVS HEAD. In the administration settings, choose 'SQL' as the driver for
shares and be sure to run the upgrade scripts located in the various
[appname]/scripts/upgrades directory.