From owner-freebsd-database Sat Nov 28 05:46:54 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id FAA14136 for freebsd-database-outgoing; Sat, 28 Nov 1998 05:46:54 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from fallout.campusview.indiana.edu (fallout.campusview.indiana.edu [149.159.1.1]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id FAA14131 for ; Sat, 28 Nov 1998 05:46:52 -0800 (PST) (envelope-from jfieber@fallout.campusview.indiana.edu) Received: from localhost (jfieber@localhost) by fallout.campusview.indiana.edu (8.9.1/8.9.1) with ESMTP id IAA16048; Sat, 28 Nov 1998 08:41:33 -0500 (EST) Date: Sat, 28 Nov 1998 08:41:33 -0500 (EST) From: John Fieber To: Yani Brankov cc: andrew@squiz.co.nz, database@FreeBSD.ORG Subject: Re: Mysql 321 - Mysql 322 - msql In-Reply-To: <365F6419.41C67EA6@bulinfo.net> 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, 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. Nor does it have (last I checked) subqueries or views which eliminate fairly large classes of useful queries. But, if you can live without these features, mySQL is a real speed demon and an excellent for database backed web sites. In working with the two, I've also found a couple complicated join queries where I just couldn't get the optimizer in PostgreSQL (6.3.2 and 6.4) to do the right thing, resulting in several minutes of processing per query, while mySQL did the same query in the blink of an eye. -john To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message