Not to open a can of worms here, Mary, but I'd love to know exactly how you got those results, since they basically contradict every known benchmark I have seen (at least those not funded by M$... this being one: http://www.eweek.com/article2/0,3959,293,00.asp) as well as every benchmarking test I have run myself.
My results, frankly, have not been close -- not even in the same ballpark. So I suspect if you are getting different results it has something to do with your configuration. Just for the record: I'm not particularly anti-MS. I like Windows XP, I think they make some decent software (Access and Excel are what I teach on most often). And you do get a lot of nice features with SQL Server -- speed just doesn't happen to be one of them. Regards, aron > -----Original Message----- > From: Mary Stickney [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 16, 2002 9: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
