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

  Andy McKay.

----- Original Message -----
From: "Tim McLaughlin" <[EMAIL PROTECTED]>
To: "'Schmidt, Allen J.'" <[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
> 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
> 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
> be working fine (and I guess it still does) but it is slowing our whole
> 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
> 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
> the single threadedness of either the DA or Win2K ODBC driver or
> 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
> Subject: Re: [Zope-dev] ZODBCA questions...
> Andy-
> We've had no probs with ZODBCDA  connected to SQL Server (7 and 2000).
> leads you to think it's a prob with the DA?
> Tim
> Message: 2
> From: "Andy McKay" <[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
> sites and / or a suggestion to replace it?
> Cheers.
> --
>   Andy McKay.
> _______________________________________________
> Zope-Dev maillist  -  [EMAIL PROTECTED]
> **  No cross posts or HTML encoding!  **
> (Related lists -
> )

Zope-Dev maillist  -  [EMAIL PROTECTED]
**  No cross posts or HTML encoding!  **
(Related lists - )

Reply via email to