Re: [phpGroupWare-developers] caching static data

[Dave Hall]

On Thu, 2007-11-15 at 20:58 +0100, Sigurd Nes wrote:
> Hi all,
> 
> We have a caching feature based on shm in API which in most cases is working 
> well.
> In some cases it can't be used - and I propose to add a caching-table to hold 
> compiled and static data which should survive a reboot.
> This could be acl-userlists per location, generated queries and things like 
> that.
> 
> I have used this approach in the app property - but I also think that ACL 
> could benefit from it when shm is not an option
> 
> schema:
> 'phpgw_cache' => array(
>   'fd' => array(
>     'name' => array('type' => 'varchar','precision' => '50','nullable' => 
> False),
>     'value' => array('type' => 'text','nullable' => True)
>   ),
>   'pk' => array('name'),
>   'fk' => array(),
>   'ix' => array(),
>   'uc' => array()
> ),
> 
> Any thoughts ?
> Where should it be placed ?

Why not use the existing appsession data table?  It can be cached in
there.  Just set the owner to something obvious like -1 (use a class
constant for it).  Add the code to the abstract session class to support
it.

I don't think we need another table for this.

Cheers

Dave
-- 
Dave Hall (aka skwashd)
API Coordinator
phpGroupWare
e address@hidden
w phpgroupware.org
j address@hidden
sip address@hidden
       _            ____                    __        __             
 _ __ | |__  _ __  / ___|_ __ ___  _   _ _ _\ \      / /_ _ _ __ ___ 
| '_ \| '_ \| '_ \| |  _| '__/ _ \| | | | '_ \ \ /\ / / _` | '__/ _ \
| |_) | | | | |_) | |_| | | | (_) | |_| | |_) \ V  V / (_| | | |  __/
| .__/|_| |_| .__/ \____|_|  \___/ \__,_| .__/ \_/\_/ \__,_|_|  \___|
|_|         |_|                         |_|Web based collaboration platform