We are using ZmxODBC for a bounch of ODBC databases as well on windows as on linux. Out of the box its not very well written. If you patch it here and there, it works much faster then ZODBC-DA, that is, its multithreaded. I'm not complete happy with my patches, so I dont release them in this current state. But I will do so soon. On request, I can give what I have now. Regards Tino Wildenhain Rik Hoekstra schrieb:
Paolo Quaglia wrote:
Reading the zope@zope.org archive I found one message with an interesting sentence:
[Message]
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
This isn't a maximum. It's just the default. It's easy to increase the number of connections. [/Message]
Where is this Default and How can I increase this counter?? Thanks very much in advance
AFAIK the ZODBC adapter is still single threaded. See http://www.zope.org/Members/petrilli/DARoadmap for more information, though I'm not certain wether this page is still up to date. There are rumours that for SQL Server you could use the mxODBC adapter, though I know nothing more of it. Recently there were posts on this list about using the ZSybase Adapter for SQL Server they're probably thread safe as well (?). Do a search in the archives for more info