[Zope] Defining High Load in Heavily DB Driven site (was: [Zope] zope2.2.0 and what is high load)

bak @ kedai kedai@kedai.com.my
Fri, 11 Aug 2000 23:33:13 +0800


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 )