Re: MySQL Version 4

[Wade Chandler <wchandler@xxxxxxxxxxxxxxx>]

Richard Welty wrote:

> On Tue, 16 Mar 2004 12:51:51 -0500 Wade Chandler <wchandler@xxxxxxxxxxxxxxx> wrote:
>
> > If you need a full blown server it is much cheeper than other 
> > alternatives...except for Firebird DBMS.
>
>
> PostgreSQL?
>
> richard
I like PostgreSQL as far as it's simplicity and things go.  It's nice, 
and there are some good front ends for it.  The one complaint I have 
with Postgres is that it forks.

MySQL and Firebird use threads and Postgres forks.  Forking is ok, 
unless you have many database connections.  The more connections the 
more processes.  I noticed while profiling an application that every 
connection alone was taking over 1MB of memory.  This based on the 
process per connection gripe I have.

So, Postgres, sure I like it, but as far as a major DBMS goes, I think 
it is limited by it's memory usage.  That's just my opinion on the 
matter.  However, it is a fact that it forks (forking takes more time 
and more resources than threading).  One benefit in forking is the same 
reason Apache forks( memory leaks can be minimized).  However, I think 
if a DBMS has that bad of a memory leak....I won't use it.

I like to advocate Firebird as much as possible.  It runs on many 
platforms and seems to be pretty scalable as far as connections and 
usage goes, and it has a very flexible license as well.

I like all three mentioned DBMS, just different reasons for using them 
at different times.

Wade