RE: [Zope-dev] ZODBCA questions...

2001-04-11 Thread Bryan Baszczewski

You may be interested in recent developments:
http://www.zope.org/Wikis/DevSite/Proposals/DatabaseStategy/HistoricalRevisi
ons/827.44494.7026.26188

I dont know why the DC folks havent stayed on top of ODBC.  They should.
Plenty of Zope/SQL Server users.


-Original Message-
From: Mark Pratt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 11:46 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [Zope-dev] ZODBCA questions...


Hi Andy,

I would venture a guess that your ZODBC problems have to do
with the DA being Level 1.

visit the somewhat dated URL:

http://www.zope.org/Members/petrilli/DARoadmap

for details on what Level 1 through 3 represent.

For an upcoming project we will need to work with MS SQL
server as well so I've been discussing with Paul a bit about what
it would take to fund a L3 DA. You might want to send him an
email.

Regards,

Mark

--
mark pratt  (managing director)  [EMAIL PROTECTED]
beehive elektronische medien GmbH   http://www.beehive.de
phone: +49 30 847-82 0  fax: +49 30 847-82 299



___
Zope-Dev maillist  -  [EMAIL PROTECTED]
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 )


___
Zope-Dev maillist  -  [EMAIL PROTECTED]
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 )



Re: [Zope-dev] ZODBCA questions...

2001-04-11 Thread Chris McDonough

 You may be interested in recent developments:

http://www.zope.org/Wikis/DevSite/Proposals/DatabaseStategy/HistoricalRevisi
 ons/827.44494.7026.26188

 I dont know why the DC folks havent stayed on top of ODBC.  They should.
 Plenty of Zope/SQL Server users.

This is true.  But it's likely the aame reason we dont have an ecommerce
module or an XSLT processor or a catalog which allows for easy indexing of
pdfs or our own object-relational mapping story, or, or, or, or.

Patches accepted ;-),

- C



___
Zope-Dev maillist  -  [EMAIL PROTECTED]
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 )



RE: [Zope-dev] ZODBCA questions...

2001-04-11 Thread Bryan Baszczewski

 This is true.  But it's likely the aame reason we dont have an ecommerce
module or an XSLT processor or a catalog which allows for easy indexing of
pdfs or our own object-relational mapping story, or, or, or, or. 

It would be naive of me to assume what reason that is, but I just wondered
why ZODBC DA was left in it's current (somewhat dated, somewhat stale...but
like a old chocolate chip cookie, you'll still eat it) state.


___
Zope-Dev maillist  -  [EMAIL PROTECTED]
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 )



Re: [Zope-dev] ZODBCA questions...

2001-04-10 Thread Tim McLaughlin

Andy-
We've had no probs with ZODBCDA  connected to SQL Server (7 and 2000).  What
leads you to think it's a prob with the DA?

Tim

Message: 2
From: "Andy McKay" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Mon, 9 Apr 2001 10:45:55 -0700
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  -  [EMAIL PROTECTED]
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 )



RE: [Zope-dev] ZODBCA questions...

2001-04-10 Thread Schmidt, Allen J.

We too are having problems connecting to Access2000 with ZODBCDA. Seemed to
be working fine (and I guess it still does) but it is slowing our whole site
down. all our parts were playing together very well until (we think) about
the 2.3.x introduction.

Our site grinds to a halt and is very slow in every aspect; usually in the
morning but on and off throughout the day. We tried some caching in various
places which seemed to help for a while but it is slowing back down again.

Access2000 on Win2000 with ODBC connection to Zope with ZODBCDA. Could it be
the single threadedness of either the DA or Win2K ODBC driver or Access2000
itself?? We think we have narrowed it down to the database causing the
slowdown.

Considered a move to MySQL as it is installed. Would the ZODBCDA to MySQL
cause similar problems? Better to use the native My SQL DA?

Anyone else running into same problems? Have any options to try? Thanks

Allen
-Original Message-
From: Tim McLaughlin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 7:51 AM
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: Re: [Zope-dev] ZODBCA questions...


Andy-
We've had no probs with ZODBCDA  connected to SQL Server (7 and 2000).  What
leads you to think it's a prob with the DA?

Tim

Message: 2
From: "Andy McKay" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Mon, 9 Apr 2001 10:45:55 -0700
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  -  [EMAIL PROTECTED]
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 )

___
Zope-Dev maillist  -  [EMAIL PROTECTED]
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 )



RE: [Zope-dev] ZODBCA questions...

2001-04-10 Thread Tim McLaughlin

actually, our SQL Server sites are using 2.2.X, so it could be something 2.3
related.  were there any aqueduct or other RDB changes done between those
versions?  (I don't know of any, but I haven't looked)

pertaining to MySQL, definitely use the native DA since ODBC will simply put
an unnecessary layer in between Zope and the db.

Tim

-Original Message-
From: Schmidt, Allen J. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 8:29 AM
To: 'Tim McLaughlin'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: RE: [Zope-dev] ZODBCA questions...


We too are having problems connecting to Access2000 with ZODBCDA. Seemed to
be working fine (and I guess it still does) but it is slowing our whole site
down. all our parts were playing together very well until (we think) about
the 2.3.x introduction.

Our site grinds to a halt and is very slow in every aspect; usually in the
morning but on and off throughout the day. We tried some caching in various
places which seemed to help for a while but it is slowing back down again.

Access2000 on Win2000 with ODBC connection to Zope with ZODBCDA. Could it be
the single threadedness of either the DA or Win2K ODBC driver or Access2000
itself?? We think we have narrowed it down to the database causing the
slowdown.

Considered a move to MySQL as it is installed. Would the ZODBCDA to MySQL
cause similar problems? Better to use the native My SQL DA?

Anyone else running into same problems? Have any options to try? Thanks

Allen
-Original Message-
From: Tim McLaughlin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 7:51 AM
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: Re: [Zope-dev] ZODBCA questions...


Andy-
We've had no probs with ZODBCDA  connected to SQL Server (7 and 2000).  What
leads you to think it's a prob with the DA?

Tim

Message: 2
From: "Andy McKay" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Mon, 9 Apr 2001 10:45:55 -0700
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  -  [EMAIL PROTECTED]
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 )

___
Zope-Dev maillist  -  [EMAIL PROTECTED]
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 )



Re: [Zope-dev] ZODBCA questions...

2001-04-10 Thread Andy McKay

 Considered a move to MySQL as it is installed. Would the ZODBCDA to MySQL
 cause similar problems? Better to use the native My SQL DA?

MySQL rocks, but comes short in some of the areas we need. MSSQL is the one
constraint on this project that I cant get around.

Cheers.
--
  Andy McKay.


- Original Message -
From: "Schmidt, Allen J." [EMAIL PROTECTED]
To: "'Tim McLaughlin'" [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, April 10, 2001 5:28 AM
Subject: RE: [Zope-dev] ZODBCA questions...


 We too are having problems connecting to Access2000 with ZODBCDA. Seemed
to
 be working fine (and I guess it still does) but it is slowing our whole
site
 down. all our parts were playing together very well until (we think) about
 the 2.3.x introduction.

 Our site grinds to a halt and is very slow in every aspect; usually in the
 morning but on and off throughout the day. We tried some caching in
various
 places which seemed to help for a while but it is slowing back down again.

 Access2000 on Win2000 with ODBC connection to Zope with ZODBCDA. Could it
be
 the single threadedness of either the DA or Win2K ODBC driver or
Access2000
 itself?? We think we have narrowed it down to the database causing the
 slowdown.

 Considered a move to MySQL as it is installed. Would the ZODBCDA to MySQL
 cause similar problems? Better to use the native My SQL DA?

 Anyone else running into same problems? Have any options to try? Thanks

 Allen
 -Original Message-
 From: Tim McLaughlin [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 10, 2001 7:51 AM
 To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
 Subject: Re: [Zope-dev] ZODBCA questions...


 Andy-
 We've had no probs with ZODBCDA  connected to SQL Server (7 and 2000).
What
 leads you to think it's a prob with the DA?

 Tim

 Message: 2
 From: "Andy McKay" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Date: Mon, 9 Apr 2001 10:45:55 -0700
 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  -  [EMAIL PROTECTED]
 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 )



___
Zope-Dev maillist  -  [EMAIL PROTECTED]
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 )



Re: [Zope-dev] ZODBCA questions...

2001-04-10 Thread Andy McKay

Hmmm, interesting I will check the changes. Just curious if you tried the
sites under heavy load, 50 odd request per second+

Cheers.
--
  Andy McKay.


- Original Message -
From: "Tim McLaughlin" [EMAIL PROTECTED]
To: "'Schmidt, Allen J.'" [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, April 10, 2001 5:45 AM
Subject: RE: [Zope-dev] ZODBCA questions...


 actually, our SQL Server sites are using 2.2.X, so it could be something
2.3
 related.  were there any aqueduct or other RDB changes done between those
 versions?  (I don't know of any, but I haven't looked)

 pertaining to MySQL, definitely use the native DA since ODBC will simply
put
 an unnecessary layer in between Zope and the db.

 Tim

 -Original Message-
 From: Schmidt, Allen J. [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 10, 2001 8:29 AM
 To: 'Tim McLaughlin'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
 Subject: RE: [Zope-dev] ZODBCA questions...


 We too are having problems connecting to Access2000 with ZODBCDA. Seemed
to
 be working fine (and I guess it still does) but it is slowing our whole
site
 down. all our parts were playing together very well until (we think) about
 the 2.3.x introduction.

 Our site grinds to a halt and is very slow in every aspect; usually in the
 morning but on and off throughout the day. We tried some caching in
various
 places which seemed to help for a while but it is slowing back down again.

 Access2000 on Win2000 with ODBC connection to Zope with ZODBCDA. Could it
be
 the single threadedness of either the DA or Win2K ODBC driver or
Access2000
 itself?? We think we have narrowed it down to the database causing the
 slowdown.

 Considered a move to MySQL as it is installed. Would the ZODBCDA to MySQL
 cause similar problems? Better to use the native My SQL DA?

 Anyone else running into same problems? Have any options to try? Thanks

 Allen
 -Original Message-
 From: Tim McLaughlin [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 10, 2001 7:51 AM
 To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
 Subject: Re: [Zope-dev] ZODBCA questions...


 Andy-
 We've had no probs with ZODBCDA  connected to SQL Server (7 and 2000).
What
 leads you to think it's a prob with the DA?

 Tim

 Message: 2
 From: "Andy McKay" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Date: Mon, 9 Apr 2001 10:45:55 -0700
 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  -  [EMAIL PROTECTED]
 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 )



___
Zope-Dev maillist  -  [EMAIL PROTECTED]
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 )



Re: [Zope-dev] ZODBCA questions...

2001-04-10 Thread Andy McKay

Under heavy loads (stress testing) I get a lot of sql.errors, ive just
started logging those so I can get exact numbers. Im getting memory leaks,
but Im not sure if that is ZODBCA or not.

Cheers.
--
  Andy McKay.


- Original Message -
From: "Tim McLaughlin" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, April 10, 2001 4:50 AM
Subject: Re: [Zope-dev] ZODBCA questions...


 Andy-
 We've had no probs with ZODBCDA  connected to SQL Server (7 and 2000).
What
 leads you to think it's a prob with the DA?

 Tim

 Message: 2
 From: "Andy McKay" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Date: Mon, 9 Apr 2001 10:45:55 -0700
 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  -  [EMAIL PROTECTED]
 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 )



___
Zope-Dev maillist  -  [EMAIL PROTECTED]
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 )



Re: [Zope-dev] ZODBCA questions...

2001-04-10 Thread Andy McKay

Thanks, well the consensus was that it was level 2. We've talked to Paul
quite a bit about the database adapters for Zope and I'd always said they
work fine for me. Oops :)

Cheers.
--
  Andy McKay.


- Original Message -
From: "Mark Pratt" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, April 10, 2001 8:45 AM
Subject: Re: [Zope-dev] ZODBCA questions...


 Hi Andy,

 I would venture a guess that your ZODBC problems have to do
 with the DA being Level 1.

 visit the somewhat dated URL:

 http://www.zope.org/Members/petrilli/DARoadmap

 for details on what Level 1 through 3 represent.

 For an upcoming project we will need to work with MS SQL
 server as well so I've been discussing with Paul a bit about what
 it would take to fund a L3 DA. You might want to send him an
 email.

 Regards,

 Mark

 --
 mark pratt  (managing director)  [EMAIL PROTECTED]
 beehive elektronische medien GmbH   http://www.beehive.de
 phone: +49 30 847-82 0  fax: +49 30 847-82 299



 ___
 Zope-Dev maillist  -  [EMAIL PROTECTED]
 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 )



___
Zope-Dev maillist  -  [EMAIL PROTECTED]
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 )



Re: [Zope-dev] ZODBCA questions...

2001-04-09 Thread Andy McKay

Well I havent been able to prove its ZODBCA yet... the other alternative is
perlDBI but that has a small performance hit.

Cheers.
--
  Andy McKay.


- Original Message -
From: "Bryan Baszczewski" [EMAIL PROTECTED]
To: "'Andy McKay'" [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
 Sent: Monday, April 09, 2001 1:46 PM
 To: [EMAIL PROTECTED]
 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  -  [EMAIL PROTECTED]
 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 )



___
Zope-Dev maillist  -  [EMAIL PROTECTED]
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 )



Re: [Zope-dev] ZODBCA questions...

2001-04-09 Thread Andy McKay

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" [EMAIL PROTECTED]
To: "'Andy McKay'" [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
 Sent: Monday, April 09, 2001 1:46 PM
 To: [EMAIL PROTECTED]
 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  -  [EMAIL PROTECTED]
 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 )



___
Zope-Dev maillist  -  [EMAIL PROTECTED]
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 )



RE: [Zope-dev] ZODBCA questions...

2001-04-09 Thread Bryan Baszczewski

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:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 3:20 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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" [EMAIL PROTECTED]
To: "'Andy McKay'" [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
 Sent: Monday, April 09, 2001 1:46 PM
 To: [EMAIL PROTECTED]
 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  -  [EMAIL PROTECTED]
 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 )




___
Zope-Dev maillist  -  [EMAIL PROTECTED]
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 )



Re: [Zope-dev] ZODBCA questions...

2001-04-09 Thread Matthew T. Kromer

ZODBCA is on my list of things to evaluate freshing...  there is a good
chunk of code out there for a CLI interface.  One of the project wikis
mentions it somewhat, which I'll update on dev.zope.org as I get better
details.

The downside is I am not an NT evangelist; I'm more like a penguin in a
demilitarized zone.  Now, if we were talking SQL/DS on VM; I'd happily crank
out 370 asm bindings for REXX :)  I even used to have one of those cool
orange plasma tubes (but what you didn't probably know is that they were
SLOW to refresh.)


- Original Message -
From: "Andy McKay" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 09, 2001 1:45 PM
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  -  [EMAIL PROTECTED]
 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 )



___
Zope-Dev maillist  -  [EMAIL PROTECTED]
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 )