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:mary.stickney@stripped]
Sent: Friday, August 16, 2002 8:53 AM
To: Francisco; Elizabeth Bogner; mysql@stripped
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:frsgti@stripped]
Sent: Friday, August 16, 2002 8:47 AM
To: Mary Stickney; Elizabeth Bogner; mysql@stripped
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 <mary.stickney@stripped> 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:elizabeth.bogner@stripped]
> Sent: Thursday, August 15, 2002 9:25 PM
> To: mysql@stripped
> 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
> <mysql-thread117260@stripped>
> To unsubscribe, e-mail
>
<mysql-unsubscribe-mary.stickney=tagtmi.com@stripped>
> 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
> <mysql-thread117305@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-frsgti=yahoo.com@stripped>
> 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 <mysql-thread117315@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-Kenneth.Hylton=billingconcepts.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
