Hi, Thanks for all the answers for running Zope (Linux) and MS-SQL(WinNT). Now I have a different scenario. In case I use Win2K and MS-SQL-Server 2000, I need to use ZODBCDA. Now my question is that does Zope use connection pooling how do I configure that? If not, then suppose I get 10 database requests, does it put them in queue (opening only one connection) or it executes them parallely opening 10 separate connections? Thanks, Peeyush Garg.
It uses the configuration set on the ODBC DSN I think. At least that is what appears to happen. Adrian... -- The difficulty of tactical maneuvering consists in turning the devious into the direct, and misfortune into gain. - Sun Tzu ----- Original Message ----- From: "Peeyush Garg" <peeyushg@karna.com> To: <zope-dev@zope.org> Sent: Wednesday, January 30, 2002 12:41 AM Subject: [Zope-dev] Urgent help required Hi, Thanks for all the answers for running Zope (Linux) and MS-SQL(WinNT). Now I have a different scenario. In case I use Win2K and MS-SQL-Server 2000, I need to use ZODBCDA. Now my question is that does Zope use connection pooling how do I configure that? If not, then suppose I get 10 database requests, does it put them in queue (opening only one connection) or it executes them parallely opening 10 separate connections? Thanks, Peeyush Garg.
It uses the configuration set on the ODBC DSN I think. At least that is what appears to happen.
AFAIK ZODBCA is only single threaded though, ZmxODBCA should be a better bet. There is a Zope-DB list BTW and Matt "Mr Zope RDBMS guru" Kromer hangs out there a lot. -- Andy McKay
Andy McKay wrote:
It uses the configuration set on the ODBC DSN I think. At least that is what appears to happen.
AFAIK ZODBCA is only single threaded though, ZmxODBCA should be a better bet.
There is a Zope-DB list BTW and Matt "Mr Zope RDBMS guru" Kromer hangs out there a lot. -- Andy McKay
I *definately* recommend ZmxODBCA over what we have -- we have some SWIG generated code that's old and crufty -- it works, but it isn't being maintained. I do not have the time to vest in creating a new ODBC adapter for Zope. -- Matt Kromer Zope Corporation http://www.zope.com/
participants (4)
-
Adrian Hungate -
Andy McKay -
Matthew T. Kromer -
Peeyush Garg