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
