[Tickets #3280] NEW: Share information access within DataTree is too 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=3280
-----------------------------------------------------------------------
 Ticket             | 3280
 Created By         | leena.heino at uta.fi
 Summary            | Share information access within DataTree is too slow
 Queue              | Horde Framework Packages
 Version            | FRAMEWORK_3
 State              | Unconfirmed
 Priority           | 3. High
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------


leena.heino at uta.fi (2006-01-17 00:38) wrote:

We tried to use the H3 x.1 rc versions of the horde, imp, turba, kronolith,
nag, mnemo. It seems that DataTree performace is once again an update
blocker. This time it is the way the share information is saved, read and
accessed from DataTree.

It seems that share information is used and accessed more often compared to
H3 x.0 versions. This means that DataTree is accessed more often and this
results to sql queries that take far to long to complete. Single share
related query from DataTree can take tens of seconds to complete.

Would it be possible to remove share information from DataTree and change it
to use flat database table. Change similar to the way history information
was removed from DataTree.