Re: selecting DB on linux

["Thomas O'Dowd" <tom@example.com>]

If you haven't looked at PostgreSQL since 6.x, then you'll see a vastly
improved server. I'd say it scores well in all areas you are looking
for although mysql will probably be that bit faster. You'll want the
latest version 7.1.2. I've never bothered with mysql though since I 
need transactions so I can't really comment on the differences.

Cheers,

Tom.

On Thu, Jun 14, 2001 at 11:58:00AM +0900, Jonathan Shore wrote:
> 
> I'm moving away from oracle on Linux (a monster of a DB which was a
> nightmare to install and maintain) and looking to replace with another DB.  
> 
> I'm looking for a DB which has a balance of the following:
> 
> *	conservative memory & cpu footprint (when not in use)
> *	db recoverability (machine may go up and down unexpectedly) [sounds
> bizzare but can explain if anyone is interested].
> *	reasonable performance, but with an architecture that can scale
> *	SQL compliance
> 
> The first 2 bullets is especially important as will be using on devices with
> small memory footprints (256MB) and limited CPU time (other processes will
> dominate).  In this scenario, expect few transactions, mostly DB reads.
> [btw, never had any intention of using oracle in this scenario - wouldn't
> even get a server running in this env].
> 
> Ideas on how postgresql, mysql, or other DBs would fit this profile?
> 
> JS



-- 
Thomas O'Dowd. - Nooping - http://nooper.com
tom@example.com - Testing - http://nooper.co.jp/labs