After reading this about Level 2: <<"While a sub-optimal solution, it should be usable on any application that has minimal, or infrequent, database access">> Then about the ZODBC DA itself: <<"Long term progress. See information below on the future of a X/Open CLI interface DA." ...blah blah blah... "we will be transitioning to a new design for the ODBC DA, as well as integrating support for IBM DB2 into the same DA.">> I would not use ZODBC & SQL Server for my critical business apps as it looks like its going away. -----Original Message----- From: Andy McKay [mailto:andym@ActiveState.com] Sent: Monday, April 09, 2001 3:20 PM To: bryanbz@2s2i.com Cc: zope-dev@zope.org Subject: Re: [Zope-dev] ZODBCA questions... According to the Database Adapter RoadMap (http://www.zope.org/Members/petrilli/DARoadmap), ZODBCA will be level 2 compliant at one point. Yet ZODBCA hasnt been touched since 1999. Is ZODBCA level 2 compliant? Cheers. -- Andy McKay. ----- Original Message ----- From: "Bryan Baszczewski" <bryanbz@2s2i.com> To: "'Andy McKay'" <andym@ActiveState.com> Sent: Monday, April 09, 2001 11:28 AM Subject: RE: [Zope-dev] ZODBCA questions...
Andy, We experienced bigtime problems with ZODBC too. ZODBC locked all other requests out when waiting for a complex query. Upgrade to ZmxODBC database adapter (search on zope.org to find it). We found ZmxODBC to be alot better without locking requests. BUT...it costs money(!) and seems no one else uses this though as SQL Server isnt widely supported by Digital Creations. A shame really being that SQL Server is an excellent database.
For verificaion of your problem, check out the plans for ZODBC the "Database Adapter RoadMap".
-----Original Message----- From: Andy McKay [mailto:andym@ActiveState.com] Sent: Monday, April 09, 2001 1:46 PM To: zope-dev@zope.org Subject: [Zope-dev] ZODBCA questions...
Im getting some performance issues with my sites, im connecting Zope to a SQL Server (not using ZEO). I've got suspicion, but no proof, that its ZODBCA that is the problem. Does anyone have experiences with this on large sites and / or a suggestion to replace it?
Cheers. -- Andy McKay.
_______________________________________________ Zope-Dev maillist - Zope-Dev@zope.org http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )