[Zope-dev] ZODBCA questions...

Bryan Baszczewski bryanbz@2s2i.com
Mon, 9 Apr 2001 16:08:54 -0400


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 )
>