[Zope] Performance Hit

[BZ]

Squid would help cache static content but not really on the backend
database. I think Dieter was talking about ZSQL caching and RAM Caching
within Zope both which will save you a lot of SQL calls.

It has been awhile since I built a Zope website with a SQL backend, but
from what I remember, going through each one of my ZSQL methods and
figuring out how often they needed to be updated and caching them for that
specific period of time greatly helped in performance.

For some things, since the SQL database is more a read, you can cache
results for 10 mins up to 24 hours.

BZ

> Thanks. I am of the opinion that adding a Squid server for this
> non-dynamic
> content would solve almost all problems. Your thoughts?
> beno
>
> At 09:18 AM 9/5/2003 -0500, you wrote:
>>Here our MySQL database is on a separate server than our Apache and Zope
>>servers
>>we serve 100's of thousands of requests per day, if we were to serve
>> parts
>>of our content
>>from MySQL there would definitely be a noticeable hit to our request
>> times.
>>
>>Now if we are just talking about a 10 page website that serves 100 or so
>>requests per day
>>you probably wouldn't notice at all. It is all dependent on the amount of
>>data, and the
>>amount of traffic, I went with the worst case point of view, large
>> amounts
>>of content
>>served from a remote database, with high traffic, as opposed to serving
>>static content
>>from the webserver.
>>
>>We have about 60 sites that use our Zope server, two fairly large sites,
>>and we experience
>>slow response times just serving from the ZODB. When one of the agencies
>> puts
>>out a document for the public and it gets hit hard, we notice it. Granted
>>it doesn't DoS
>>us, and we are able to work normally, there is a definite slow down in
>>network traffic.
>>
>>
>>Chris Withers wrote:
>>
>>>Jason Bush wrote:
>>>
>>>>There would be performance issues indeed, and it would be come more
>>>>pronounced
>>>>with greater amounts of traffic to you website.
>>>
>>>
>>>What information are you basing this on?
>>>
>>>Chris
>>
>>--
>>"When two men in business always agree, one of them is
>>unneccessary."                                                 --William
>>Wrigley Jr.
>>Jason Bush  |  (402) 471-6517  |  jason at nol.org  |  http://www.nol.org
>>
>>
>>
>>_______________________________________________
>>Zope maillist  -  Zope at zope.org
>>http://mail.zope.org/mailman/listinfo/zope
>>**   No cross posts or HTML encoding!  **
>>(Related lists - http://mail.zope.org/mailman/listinfo/zope-announce
>>http://mail.zope.org/mailman/listinfo/zope-dev )
>
>
>
> _______________________________________________
> Zope maillist  -  Zope at zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )
>