Regarding your testing... did you test many concurrent processes or concurrent multi-user access? If you need concurrent multi-user access for an OLTP app then you should test it.
To this end I developed a Perl routine which launched concurrent sessions in the background. I could adjust the number of concurrent sessions via arguments passed to the program. Each session performed a series of SQL statements involving a real world mix of selects, inserts, updates and deletes with pseudo random values provided for key column ranges. As soon as I cranked up the volume to around 20 concurrent sessions MySQL barfed but Oracle scaled much higher without a hitch. MySQL is great for raw speed with individual queries or batch inserts but it doesn't seem to scale as well with OLTP apps having many concurrent sessions. I'm hoping this will change with InnoDB and future enhancements as MySQLAB strives for ANSI compatibility like the other guys (PostgreSQL and Interbase). -----Original Message----- From: Kenneth Hylton [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 10:47 AM To: [EMAIL PROTECTED] Subject: RE: MySQL vs. Oracle (not speed) Our experience has been totally the opposite. We recently ported a Delphi application from MS-SQL to MySQL. The MySQL server was a less powerful box than MS-SQL was running on. I will not go into great detail because some of the software is proprietary and we make $$$ providing the service. But here are out times: Process #1 (heavy inserts, few updates) MS-SQL 9 hours MySQL 90 minutes Process #2 (heavy updates, few inserts) MS-SQL 17 hours MySQL 2.5 hours The databases were tuned to get maximum performance from MS-SQL (you can see why) and NO changes were made to optimize for MySQL, as we didn't need to. Ken Hylton Programmer Analyst IV LEC Systems & Programming Billing Concepts, Inc. 7411 John Smith Drive San Antonio, Texas 78229-4898 (210) 949-7261 -----Original Message----- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 8:53 AM To: Francisco; Elizabeth Bogner; [EMAIL PROTECTED] Subject: RE: MySQL vs. Oracle (not speed) I have been doing speed tests.... the same query ran on MYSQL took 45 minutes on MS-SQL it took 11 minutes...... yes you do get what you pay for.... -----Original Message----- From: Francisco [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 8:47 AM To: Mary Stickney; Elizabeth Bogner; [EMAIL PROTECTED] Subject: RE: MySQL vs. Oracle (not speed) Hi, I am beging using MySQL for quite a while and it is a very good choice if you don't really need stored procedures. MySQL provides a pretty good implementation of a subset of MySQL-92, performance is great, it is cross-platform, provides transactions, and its price... well is free. Hope it helps. --- Mary Stickney <[EMAIL PROTECTED]> wrote: > > It doesn't suport alot of differnt things.... > it dosent have store procedures , dosent have a > complete SQL command set... > > I am using it becasue I am being forced to... > > > > -----Original Message----- > From: Elizabeth Bogner > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 9:25 PM > To: [EMAIL PROTECTED] > Subject: MySQL vs. Oracle (not speed) > > > > A company I work with is in the process of upgrading > its databases from > some > motheaten system to something current. My impression > is that they > want to go with Oracle, and I'm not sure if this is > based on anything > other than being impressed with the size and > presumed quality support > of Oracle. I'd like to encourage them to at least > seriously consider > using > MySQL instead. > > I don't think that speed is a huge factor here; we > do a lot of XML > publishing > and content management, but at most we'd have > several gigabytes of > data and several dozen simultaneous users, so well > within the > capabilities > of MySQL. I've looked at various things I could > find, like the benchmarks > pages (probably not relevant) and the MySQL myths > page, which was > somewhat helpful, but I couldn't find anything more > along the lines of > "How to Convince my Management to go with MySQL." I > don't even know > what to expect from them, but I'm imagining they'll > say, "But MySQL > doesn't support sub-selects," to which I can reply, > "But you can write > most of those as joins anyway, so it won't matter > because the software > will all be written from scratch." Etc. > > Are there pointers anyone can give me? > > E. Bognewitz > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php