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 )
