[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