Re: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-07-04 Thread Monty Taylor
Original Message On 7/4/00, 12:47:07 AM, Andy Dustman [EMAIL PROTECTED] wrote regarding Re: [Zope] MySQL transaction support (was: MySQL Select Statements): Note also: With non-transactional databases, you would expect to get better performance by having several open connections which

RE: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-07-03 Thread Andy Dustman
On Mon, 3 Jul 2000, Monty Taylor wrote: Why not have one ZmySQLDA that attempts to determine whether it is transactional or not when the connect method is executed. That way you could have a DA connect to your 3.22 database, upgrade your database to 3.23.15 and not see any problems. A

Re: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-07-03 Thread Hannu Krosing
Andy Dustman wrote: There are two factors which determine whether or not transactions can be supported. Actually, there's only one, but it can't be directly tested for: 1) If the server version (easily obtained upon establishing the connection) is 3.23.15, transactions are definitely

Re: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-07-03 Thread Andy Dustman
On Tue, 4 Jul 2000, Hannu Krosing wrote: AFAIK the transaction support is enabled on table-by-table basis, so there is no way to know for sure if transactions are supported/partially-supported/unsupported for a particular set of queries True enough. There are several problems here: 1)

RE: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-06-30 Thread Ron Bickers
-Original Message- From: Andy Dustman [mailto:[EMAIL PROTECTED]] Sent: Friday, June 30, 2000 1:25 PM To: Ron Bickers Cc: Michael Blewett; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [Zope] MySQL Select Statements That's the problem: They don't get control over when