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@nol.org | http://www.nol.org
_______________________________________________ Zope maillist - Zope@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@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 )