in general, when a thread attempts to do anything with zope it needs to get hold of a ZODB connection so it can read or otherwise manipulate objects in the ZODB. this is why the number of application threads should be smaller than the number of ZODB connections. tweaking these numbers is possible, but mileage may vary depending on your specific site and usage. ------- as noted by chris M, if i were to bump up the zodn connection pool, it better be more than the app thread, right? so, in my previous case, i increased the app threads to be more than the zodb connection pool. what does this entail? i'm not too sure. i intend to increase the app thread number and the connection pool number, to see whether these increase will have any effeect on my currently loaded site. one tiny question, what will all these do to my rdb connection. my DA is not thread safe, me think. (ZPYgreSql) jens thanks ---- Jens Vagelpohl jens@digicool.com Software Engineer www.digicool.com Digital Creations (888) 344-4332 Got Zope? ----
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Dario Lopez-Kästen Sent: Friday, August 11, 2000 07:10 To: zope@zope.org Subject: [Zope] Defining High Load in Heavily DB Driven site (was: [Zope] zope2.2.0 and what is high load)
Hello!
I need to find more info on how Zope handles threading with relation to database connections.
I am currently considering and evaluating Zope as one of the options we have to build a really large, completely databasedriven "enterprise scale" web-platform. I am a bit worried about this "maximum of 7 threads per db connection" limitation mentioned previously, and I need to know a) what does this mean in terms of accesibility, b) how does it affect performace, and c) how does Zope work (in detail) with external database connections.
We are going to be using Oracle as our DB backend, all our served data will be database *only* (some of it will be fairly large), and efficient database connections is *crucial* to what we intend to do.
We are going to have between 10-20k users at most and I expect the maximun of simultaneous connections to be beween 400 - 900 under heavy load; "normal load" will probably oscillate around 25-200 simultaneous connections (these numbers are crude guesses, but take into account increased usage over time as more services are provided in the future).
Bandwith problems are not an issue, nor is computing power.
I would appreciate any pointers to documentation or people to ask.
Sincerely,
/dario
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )