From owner-freebsd-database Sat Nov 28 22:49:23 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id WAA29911 for freebsd-database-outgoing; Sat, 28 Nov 1998 22:49:23 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from aniwa.sky (p25-nas1.wlg.ihug.co.nz [216.100.145.25]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id WAA29906 for ; Sat, 28 Nov 1998 22:49:17 -0800 (PST) (envelope-from andrew@squiz.co.nz) Received: from localhost (andrew@localhost) by aniwa.sky (8.8.8/8.8.7) with ESMTP id OAA08482; Sun, 29 Nov 1998 14:37:10 +1300 (NZDT) (envelope-from andrew@squiz.co.nz) Date: Sun, 29 Nov 1998 14:37:09 +1300 (NZDT) From: Andrew McNaughton X-Sender: andrew@aniwa.sky Reply-To: andrew@squiz.co.nz To: The Hermit Hacker cc: Yani Brankov , database@FreeBSD.ORG Subject: Re: Mysql 321 - Mysql 322 - msql In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Sat, 28 Nov 1998, The Hermit Hacker wrote: > On Sat, 28 Nov 1998, Yani Brankov wrote: > > > Andrew McNaughton wrote: > > > > > > > It's possibly stronger on features, but it's slower than mysql. It is > > > speed he's emphasizing. > > > > > > > Yes. It's much stronger on features, but (i heard, never tried it) mysql > > doesn't have commit/rollback command. It's a very big disadvantage. > > The last time this was discussed on the PostgreSQL lists, the > argument went that mySQL can't call itself a true RDBMS because it doesn't > support one thing that was considered to be *crucial* to any > RBDMS...transactions > > Whether this is still true or not, I don't know, since I don't use > MySQL... >From the version 3.21.29 documentation: * 18.8 Some things we don't have any plans to do. * * Transactions with rollback (we mainly do selects, and because we * don't do transactions we can be much quicker on everything else). * We will support some kind of atomic operations on multiple tables * though. Currently atomic operations can be done with LOCK * TABLES/UNLOCK TABLES but we will make this more automatic in the * future. How much of a problem this is depends on how many threads are going to be trying to get at the tables at once. Andrew McNaughton To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message