[Tickets #3661] Since Horde 3.1 Update Turba Addressbook is unusable slow

[bugs@bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/?id=3661
-----------------------------------------------------------------------
 Ticket             | 3661
 Updated By         | mjones at otsc.com
 Summary            | Since Horde 3.1 Update Turba Addressbook is unusable slow
 Queue              | Horde Framework Packages
 Version            | FRAMEWORK_3
 State              | Unconfirmed
 Priority           | 3. High
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------


mjones at otsc.com (2006-04-14 23:01) wrote:

> Hello
>
> Since update from 3.0.9 to 3.1 the Turba addressbook is incredibly 
> slow.  From debug horde.log:

I am experiencing the same slow response with 3.1.1 as well.  Here is the
log files with the long delay:

Apr 15 00:53:44 HORDE [debug] [turba] SQL Query by
DataTree_sql::getAttributes(): SELECT datatree_id, attribute_name AS name,
attribute_key AS "key", attribute_value AS value FROM
horde_datatree_attributes WHERE datatree_id IN (145) [on line 989 of
"/usr/share/horde/lib/Horde/DataTree/sql.php"]
Apr 15 00:56:54 HORDE [debug] [turba] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of "/usr/share/horde/lib/Horde/DataTree/sql.php"]

If I disable Turba and it's portal block, speed returns to normal.

Configured modules:
Gollem: H3 (1.0.2) 
Horde: 3.1.1 
Imp: H3 (4.1.1)
Ingo: H3 (1.1)
Kronolith: H3 (2.1.1) 
Mnemo: H3 (2.1) 
Nag: H3 (2.1) 
Passwd: H3 (3.0)
Turba: H3 (2.1)