Re: [cobalt-users] Wish List...

["Robert G. Fisher" <rfisher@xxxxxxxxxxxxxxx>]

On Mon, Aug 07, 2000 at 09:39:15AM -0700, Kris Dahl wrote:
> Sub selects can be nice, but by no means are necessary...

Agreed, but I wasn't talking about them.  It's the rare case
that they are actually useful...but still they are non-existent
in MySQL.

> But one key feature that Interbase and PostgreSQL are both 
> missing are very fast performance.  This is, of course, one 
> really nice thing about MySQL.  I am a firm believer that MySQL 
> will catch up with MSSQL, Oracle, PostgreSQL, etc. in features 
> before any of them catch up in speed.

Umm...Funny, last I checked MySQL chose NOT to implement the vast
majority of features required by the ACID test where as PostgreSQL
chose to implement them.  Transactions and rollbacks are obviously
the most important abstances from MySQL lineup.

Beyond that, for speed, try PostgreSQL without the fsync() after
every operation.  Do this and you will get comparable speed to
MySQL which means MySQL can't be syncing to disk after every write
or is somehow buffering writes.  PostgreSQL defaults to the fsync()
behavior to ensure all buffers are properly flushed and data is
committed to the drive ASAP so it will not be lost in the event
of a problem.  Although, if they implement a synchronous means
of access into the linux kernel, as they were discussing to help
Oracle run better on linux, then PostgreSQL and MySQL would stand
to benefit as well.

-- 
Robert G. Fisher		     NEOCOM Microspecialists Inc. 
System Administrator/Programmer      (540) 666-9533 x 116