Jan-Frode Myklebust writes:
Maybe you could give some advise on how to optimally do database connections. So far we're only using 4 database connections, where it looked naturally at the time. At times we see maybe 50-100 database transactions a second (mostly reads). Are there any point in splitting the load over more database connections? What about the NUMBER_OF_THREADS in z2? I set this at 80, but that's mostly a wild guess from my side. Any advise on how many threads to use for a high traffic site doing both ZODB3 and postgres/popy? Without changing Zope's code, there is an upper limit on the number of concurrent connections to the ZODB of 7. With this limit, it is not effective to set the number of threads to a significant larger value.
Dieter