[horde] Fwd: Database performance problem with Horde3/IMP4

Sebastián Calero scalero at datadec.es
Fri Dec 30 05:06:32 PST 2005


There is any work or development about caching permission in the user session??
 
I see for example that whenever I refresh the INBOX page, querys of the type:
 
Dec 27 13:28:30 HORDE [debug] [horde] SQL Query by DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM horde_datatree WHERE datatree_name = 'imp-folders' AND group_uid = 'horde.perms' ORDER BY datatree_id [on line 173 of "/u01/app/mymensajes/2.0/home/lib/Horde/DataTree/sql.php"]

it happens for each application(10 querys for me), its posible to cache this??  I can work in this task.
 
Greetings...
 
Sebastian Calero.
 
 
---------- Forwarded message ----------
From: Chuck Hagenbuch
Date: Tue, 13 Sep 2005 10:54:37 +0800 (CST)
Subject: Re: [horde] Database performance problem with Horde3/IMP4
To: 
Quoting Jan Schneider <jan at horde.org>:
> Couldn't we use the SessionObjects API, using a sensible size limit, or
> even introducing a time limit? This way the cached permission won't
> persist the complete session.
Yup, we can do that. Would that be more acceptable to folks? I'm not 
sure that it would be entirely more predictable, though... ?
-chuck
-- 
"But she goes not abroad in search of monsters to destroy." - John 
Quincy Adams
-- 
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe at lists.horde.org



More information about the horde mailing list