[plug] SQL Servers

[John Breen]

(Sorry 'bout the reply format - outlook does it, not me...)

FWIW, Oracle will happily return uncommited data to a query...


Cheers,


John

John Breen
Programmer
United Construction Pty Ltd

(08) 9499-0472
0413-462-818
john.breen at unitedconstruction.com.au




-----Original Message-----
From:	John Summerfield [SMTP:summer at os2.ami.com.au]
Sent:	Thursday, September 09, 1999 7:59 PM
To:	plug at linux.org.au
Subject:	[plug] SQL Servers

> Hi Paul
> 
> Go with Postgres. It has commit and rollback, which MySQL doesnt have.
> MySQL might be faster than Postgres but who cares! BTW MySQL is verrryy
> fast at simple queries, but its SQL is pretty restricted and the
> developers have 'cut a lot of corners' to boost performance. Also
> Postgres is GPL I think and MySQL is not (?).
> 
> FWIW There is a lot of energy behind Postgres, maybe more so than with
> MySQL.

I have used PostgresSQL. Runs like a lame dog. Couldn't see any evidence 
it has any understanding of a transaction: it cheerfully returns 
uncommitted data to an enquiry. Its not relational either.

Did I mention that it's slow?



-- 
Cheers
John Summerfield
http://os2.ami.com.au/os2/ for OS/2 support.
Configuration, networking, combined IBM ftpsites index.