Re: [Apc-aa-coders] caching in site module

[Honza M. <hon...@ec...>]

You are right. Fixed in CVS.

   Honza

P.S:=20
Your solution is good, I just changed the order of variables:

  $key_str =3D  $apc_state['state'].$site_id;

which is better for database indexes.

On St, 2003-05-21 at 16:41, Norbert Brazda wrote:
> bug is apparently on line 81 in /apc-aa/modules/site/site.php3:
>=20
>     $key_str =3D $apc_state['state'];
>=20
> Variable $apc_state['state'] is not good unique key, since it might be =
used on several sites. Better would be something like:
>=20
>     $key_str =3D $site_id.$apc_state['state'];
>=20
>=20
> norbert
> br...@ch...
>=20
>=20
> From: "Norbert Brazda" <br...@ch...>
> > There seem to an error in caching of site module(s). On yesterday I h=
ave=20
> > created two new site modules, one for www.eufondy.org and second for=20
> > www.tur.sk/new/
> >
> >=20
> > Sites use their own state files (site_eufondy.php3 and site_tur.php3)=
 with identical content (except for $slices4cache array). What I see is t=
hat one get design (defined in site module) from the other site. Bellow i=
s output of debug which shows that AA selects different ID from site tabl=
e, but receive the same cached content. I use AA version from 05/15/03.
> >=20
> > norbert
> > br...@ch...
> >=20
> > =3D=3D=3D http://www.eufondy.org/?debug=3D1 =3D=3D=3D
> >=20
> > SELECT * FROM site WHERE id =3D '=95=9EqVT=E6=A8=06=CB\\F=E9kzG=1A' t=
able type possible_keys key key_len ref rows Extra=20
> >       site const PRIMARY PRIMARY 16 const 1 =20
> >=20
> > Query duration: 0.00030696392059326
> > Rows returned: 1
> > SELECT * FROM pagecache WHERE id=3D'4282f3cd45242f307b0b8476800937b5'=
 table type possible_keys key key_len ref rows Extra=20
> >       pagecache const PRIMARY PRIMARY 32 const 1 =20
> >=20
> > Query duration: 0.0003279447555542
> > Rows returned: 1=20
> >=20
> > =3D=3D=3D
> >=20
> > =3D=3D=3D http://www.tur.sk/new/?debug=3D1 =3D=3D=3D
> >=20
> > SELECT * FROM site WHERE id =3D '.$=83y=CC=EA=C9E=8EIR$H4=A6B' table =
type possible_keys key key_len ref rows Extra=20
> >       site const PRIMARY PRIMARY 16 const 1 =20
> >=20
> > Query duration: 0.00031697750091553
> > Rows returned: 1
> > SELECT * FROM pagecache WHERE id=3D'4282f3cd45242f307b0b8476800937b5'=
 table type possible_keys key key_len ref rows Extra=20
> >       pagecache const PRIMARY PRIMARY 32 const 1 =20
> >=20
> > Query duration: 0.00035202503204346
> > Rows returned: 1=20
> >=20
> > =3D=3D=3D
> >=20
> >=20
> > -------------------------------------------------------
> > This SF.net email is sponsored by: ObjectStore.
> > If flattening out C++ or Java code to make your application fit in a
> > relational database is painful, don't do it! Check out ObjectStore.
> > Now part of Progress Software. http://www.objectstore.net/sourceforge
> > _______________________________________________
> > Apc-aa-coders mailing list
> > Apc...@li...
> > https://lists.sourceforge.net/lists/listinfo/apc-aa-coders
>=20
>=20
> -------------------------------------------------------
> This SF.net email is sponsored by: ObjectStore.
> If flattening out C++ or Java code to make your application fit in a
> relational database is painful, don't do it! Check out ObjectStore.
> Now part of Progress Software. http://www.objectstore.net/sourceforge
> _______________________________________________
> Apc-aa-coders mailing list
> Apc...@li...
> https://lists.sourceforge.net/lists/listinfo/apc-aa-coders
>=20