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 )
