[plug] setting up Linux server

[Paul Wilson]

> > On Sun, Jun 27, 1999 at 05:57:24AM +0800, John Summerfield wrote:
> > > > -----BEGIN PGP SIGNED MESSAGE-----
> > > >
> > > > > My employer wants to test a Linux server with win95 w/s, the
> > > > > server will
> > > > > be used purely for data storage while the w/s will be running a
> > > > multi
> > > > > user accounting package that uses a foxpro database,
> > > >
> > > > Why not use Linux for the database too?  I use and recommend
> > > > PostgreSQL (http://www.postgresql.org).
> > >
> > > because PostgreSQL is a toy and not good for commercial use. Its also
dead
> > > slow.
> >
> > A toy? I think that's pretty harsh. What exactly does it not do that you
want
> >  it to?
> Perform. It's slow as a one-legged dog
> Transaction logging
> Relational integrity.
> So far as I can see, it allows rows added to a table to be accessed by
> other applications before the transaction adding the rows has been
> committed.

Have you tried MySQL ?  None of the applications that I've written have
performance problems (one db has 10.5 million rows in a single table with
good access times), and you can force integrity by locking tables during
updates.  Not ideal for RDBMS purists, I agree, but it *does* work.

Paul