Date: Thu, 12 Apr 2001 18:36:35 +0200 From: Miklos Niedermayer <mico@bsd.hu> To: Phil Glatz <phil@glatz.com> Cc: freebsd-database@freebsd.org Subject: Re: help - can't build mysql Message-ID: <20010412183635.B3938@fmdb.c3.hu> 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 References: <5.0.2.1.0.20010412033249.00a8b490@dns1.rhoderunner.com> <3AD55E4C.F91693E8@svenskabutiker.se> <5.1.0.12.2.20010412072200.031d8038@flawless.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20010412183635.B3938>