Re: [Zope-dev] ZODBCA questions...
Chris McDonough wrote: > > > 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 > As for cataloging PDFs, I'm working on it (Among other formats) 8^) -- | Casey Duncan | Kaivo, Inc. | [EMAIL PROTECTED] `--> ___ 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...
;-) I think it's been kept out of triage for a while now while we've worked on getting our Catalog story straight, releasing CMF, getting ZEO to 1.0, and improved documentation. Sorry, I forget that folks aren't omniscient, and make assumptions that people know where DC's priorities are right now. Good places to get a sense of this at a high level are the "Zope Roadmap" at http://dev.zope.org/Resources/ZopeRoadmap.html and the "Zope Directions" document at http://dev.zope.org/Resources/ZopeDirections.html . On a more micro-level, a preliminary list of features planned for the next major release are at http://dev.zope.org/Resources/zope_240_plan.html . We're trying to make sense out of the current state of our relational stuff, thus the database strategy document. Hopefully we'll be able to commit resources to it to freshen it up a bit... until it gets onto the roadmap, however, we're relying (probably too much) on the community to summarize (and maybe even fix!) the problems in, for example, the current ZODBCDA implementation. Concise, repeatable bug reports help a lot. - C - Original Message - From: "Bryan Baszczewski" <[EMAIL PROTECTED]> To: "'Chris McDonough'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, April 11, 2001 2:27 PM Subject: RE: [Zope-dev] ZODBCA questions... > << 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 ) > ___ 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...
<< 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...
> 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...
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...
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...
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 )
Re: [Zope-dev] ZODBCA questions...
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...
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...
> 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...
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...
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...
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...
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 )
Re: [Zope-dev] ZODBCA questions...
Andy McKay writes: > 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? Recent posts to the list suggest that not (--> mail archives). ZmxODBCDA was said to solve the problem Dieter ___ 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...
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...
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...
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 )