[Zope] Zope + Postgresql = poor performance

[bak@nstp.com.my]

>
> If your query is pretty much the same query over and over (like a main
> webpage query), you should turn query caching on on the advanced tab fo=
r
> your ZSQL query. This will tremendously speed up accesses, and leave yo=
ur
> db available for queries which can't be cached (searches etc). If you'r=
e
> worried about missing an update, set the cache time low to say 60 secon=
ds,
> if you're happy to wait 5 mins, set it to 5 mins. All queries with the
> same arguments will come out of the cache.

i have tried this with ZPyGresDa, and it doesn't work well.  some users w=
ill=20
get a cache not found error.  can' t really remember the real error messa=
ge. =20
but this was quite sometime back, during zope-2.1 era.

haven't tried it yet with zope 2.3, or even with PoPy.

will do and report back


--=20

http://www.kedai.com.my/kk=20
http://www.kedai.com.my/eZine=20

Strange how laughter looks like crying with no sound, and raindrops taste=
=20
like tears .. without the pain