[horde] Slow address book queries

netty 2006 netty2006 at gmail.com
Fri Jan 19 02:23:04 PST 2007


Hello,

I'm running:
    * Horde: 3.1.1
    * Imp: H3 (4.1)
    * Turba: H3 (2.1)

(Yes i know i need to upgrade)

Now horde is running too slow. I see below in mysql slow query logs:
=====================================================
# Query_time: 5  Lock_time: 0  Rows_sent: 1  Rows_examined: 84412
SELECT c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN
horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id WHERE
c.group_uid = 'horde.shares.nag' AND ((a1.attribute_name = 'owner' AND
a1.attribute_value = 'xxxxxxx at xxxxx.com') OR (a1.attribute_name =
'perm_users' AND a1.attribute_key = 'xxxxxxx at xxxxx.com' AND
a1.attribute_value & 2) OR (a1.attribute_name = 'perm_creator' AND
a1.attribute_value & 2) OR (a1.attribute_name = 'perm_default' AND
a1.attribute_value & 2))   GROUP BY c.datatree_id, c.datatree_name,
c.datatree_order ORDER BY c.datatree_order, c.datatree_name,
c.datatree_id;
=====================================================

Any idea how can i speed things up?

Regards,
Netty


More information about the horde mailing list