Re: MySql vs. Oracle

Erik> Hi, I wonder is MySql controlled by transactions like Oracle or is that Erik> the reason that Oracle is much better on bigger systems.

I don't think MySql has transactions; I'm very sure it has no views (which I think are absolutely essential), and there's a host of other things it doesn't have. For some comparisons have a look at

http://www.postgresql.org/mhonarc/pgsql-general/1999-11/msg00227.html http://www.mysql.com/information/crash-me.php

(and there's prolly more to be found).

                                                                      Philip

-- 
Time passed, which, basically, is its job. -- Terry Pratchett (in: Equal Rites)
-----------------------------------------------------------------------------
Philip Lijnzaad, lijnzaad_at_ebi.ac.uk \ European Bioinformatics Institute,rm A2-24


+44 (0)1223 49 4639                 / Wellcome Trust Genome Campus, Hinxton


+44 (0)1223 49 4468 (fax)           \ Cambridgeshire CB10 1SD,  GREAT BRITAIN


PGP fingerprint: E1 03 BF 80 94 61 B6 FC  50 3D 1F 64 40 75 FB 53