[Zope] More on DB Transactions

[Tino Wildenhain]

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