[Gllug] MySQL Woes

[itsbruce at uklinux.net]

On Wed, Jun 12, 2002 at 11:38:27AM +0100, Paul Brazier wrote:
> > The reason MySQL is fast is because of all the things it doesn't
> implement.  
> 
> I think this is the crux of the matter, no such thing as a free lunch.
> If you want speed you can't have referential integrity, etc., because
> this all takes time.
> If you want the referential integrity etc., you can't have speed, the
> two are inversely proportional.

Not exactly and it's very implementation dependent.  As mentioned
elsewhere, the lack of row-level locking makes MySQL (plain MySQL, ok,
Chris;)) slower in many circumstances.

A long time back on this list there was an excellent example (thank you
Smithy) of how XFS's journalling makes some disk operations faster than
on a non-journalled system.  Sometimes the more sophisticated approach
is also the more efficient.

-- 
Bruce

-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug