Re: [Zope] More on DB Transactions
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 [EMAIL PROTECTED] 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 ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] More on DB Transactions
> Paolo Quaglia wrote: > > Reading the [EMAIL PROTECTED] 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 hth Rik ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] More on DB Transactions
Reading the [EMAIL PROTECTED] 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 dbThis isn't a maximum. It's just the default. It's easy to increase thenumber of connections. [/Message] Where is this Default and How can I increase this counter?? Thanks very much in advance Paolo QuagliaInformation Technology CoordinatorSitek S.p.A.[EMAIL PROTECTED]