From owner-freebsd-database Thu Apr 12 12: 6:28 2001 Delivered-To: freebsd-database@freebsd.org Received: from fmdb.c3.hu (dial-038.digitel2002.hu [213.163.2.38]) by hub.freebsd.org (Postfix) with SMTP id 01B9137B423 for ; Thu, 12 Apr 2001 12:06:19 -0700 (PDT) (envelope-from mico@bsd.hu) Received: (qmail 4053 invoked by uid 1003); 12 Apr 2001 16:36:35 -0000 Date: Thu, 12 Apr 2001 18:36:35 +0200 From: Miklos Niedermayer To: Phil Glatz Cc: freebsd-database@freebsd.org Subject: Re: help - can't build mysql Message-ID: <20010412183635.B3938@fmdb.c3.hu> References: <5.0.2.1.0.20010412033249.00a8b490@dns1.rhoderunner.com> <3AD55E4C.F91693E8@svenskabutiker.se> <5.1.0.12.2.20010412072200.031d8038@flawless.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <5.1.0.12.2.20010412072200.031d8038@flawless.net>; from phil@glatz.com on Thu, Apr 12, 2001 at 07:24:32AM -0700 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hi Phil! On Thu, Apr 12, 2001 at 07:24:32AM -0700, Phil Glatz wrote: > >I recomend upgrading FreeBSD instead of wasting time with this. > > Better yet, consider postgres --- I finally got the religion, and realize > what an improvement it is. In addition to be much closer to Oracle and > "true" SQL, To be much closer to "true" SQL? AFAIK it lacks many types and functions from ANSI SQL (MySQL lacks some too, but they aren't so important for 90% of people). > you'll find it outperforms mysql in many ways. I've done many > projects over the years with mysql and still find it appropriate for some, > but it's worse problem is that it just doesn't scale well. This can be > death for a popular web site. PostgreSQL *is* much slower than MySQL. I can't understand how it can outperform MySQL. Some people say that it handles concurrent queries better, but: a) tune your mysqld b) tune your queries c) tune your indices d) if you have *really* lots of queries, replicate across multiple servers and you'll be there. (I have several friends who do have problems with the performance of PostgreSQL anyway.) PostgreSQL only has transaction-safe tables, while with MySQL, you can choose from different table types. It's true that PostgreSQL has some features that MySQL doesn't, but the opposite is also true. And i think those features of MySQL are better for most people than Postgres'. http://www.mysql.com/information/crash-me.php Have a nice day Miklos To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message