Gints, Tried and could not access the web-site, you point to.
Igor Neyman, OCP DBA [EMAIL PROTECTED] ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 18, 2002 5:03 AM By default MySQL has no transactions You have to add special component to access "transactional safe tables" called Berkeley db tables. You can commit and rollback on only these tables. For others every wrong (not syntactically, but for example inserting characters into number column) insert and update will succeed. If MySQL cannot insert provided values it uses default values. One of the biggest pains is (maybe was, I don't know about MySQL 4.xxx) that it has no foreign keys :(((((((((((( I have created class diagramms for both Oracle and Mysql servers for my studies in University. It cannot be treated as feature comparison but just simple overview of these two images will show the situation i.e. compare object count on these images :-) And I have to say that Oracle diagramm isn't complete! Oracle server class diagramm http://www.itsystems.lv/gints/files/oracle/oracle_s.htm Mysql server class diagramm http://www.itsystems.lv/gints/files/mysql/mysql.htm Gints Plivna IT Sistēmas, Merķeļa 13, LV1050 Rīga http://www.itsystems.lv/gints/ "Bunyamin K. Karadeniz" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <bunyamink@havels cc: an.com.tr> Subject: Re: MySQL vs. Oracle database Sent by: [EMAIL PROTECTED] 2002.04.18 10:43 Please respond to ORACLE-L I have not been so much with MySQL , But want to share my experience. Firstly , it is very fast ...This makes me suspicious , I wonder if it is trusted to be integral . Seem like no control ..Does not contain rollbacks , may be this .. Then how does it rollback ? I have used a version where stored procs ,functions are unavailable .. Wonder if it has now.. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, April 17, 2002 10:31 PM > > > -- "Weaver, Walt" <[EMAIL PROTECTED]> > > > I don't think you're wrong. MySQL gets dissed frequently on this list, but > > it's really a nice little product. IMHO it's much closer to Oracle than > > Access. > > > > It works well for us. Doesn't scale like Oracle, but works well. > > In some ways it scales better than Oracle. For load+query > (a.k.a., "warehouse") operations it can be faster than > Oracle because it doesn't get tangled up with rollbacks, > etc. On systms with many "instances" it also can be much > simpler to administer. > > -- > Steven Lembark 2930 W. Palmer > Workhorse Computing Chicago, IL 60647 > +1 800 762 1582 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Steven Lembark > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
