List:General Discussion« Previous MessageNext Message »
From:Kenneth Hylton Date:August 16 2002 4:46pm
Subject:RE: MySQL vs. Oracle (not speed)
View as plain text  
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
Thread
MySQL vs. Oracle (not speed)Elizabeth Bogner16 Aug
  • Re: MySQL vs. Oracle (not speed)Matthew Walker16 Aug
  • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
    • RE: MySQL vs. Oracle (not speed)Kent Vilhelmsen16 Aug
    • RE: MySQL vs. Oracle (not speed)Francisco16 Aug
      • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
        • Re: MySQL vs. Oracle (not speed)Mark Matthews16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
            • Re: MySQL vs. Oracle (not speed)Mark Matthews16 Aug
              • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
              • Re: MySQL vs. Oracle (not speed)Serge Paquin16 Aug
                • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                  • Re: MySQL vs. Oracle (not speed)Mark Matthews16 Aug
                • RE: MySQL vs. Oracle (not speed)Aron Pilhofer17 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
            • Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
              • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                  • Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
                    • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                      • Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
                      • Re: MySQL vs. Oracle (not speed)Van16 Aug
                        • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                      • Re: MySQL vs. Oracle (not speed)Dan Nelson16 Aug
                        • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                      • RE: MySQL vs. Oracle (not speed)Aron Pilhofer17 Aug
        • RE: MySQL vs. Oracle (not speed)Francisco16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
            • Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
              • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                • Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
                  • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                    • Re: improving slow query (was: MySQL vs. Oracle (not speed))Benjamin Pflugmann16 Aug
                • RE: MySQL vs. Oracle (not speed)Aron Pilhofer17 Aug
            • RE: MySQL vs. Oracle (not speed) - not part of the rant, but real informationAdam Nelson16 Aug
              • Re: MySQL vs. Oracle (not speed) - not part of the rant, but real informationDavid Lloyd17 Aug
        • Re: MySQL vs. Oracle (not speed)Tom Gao16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
        • RE: MySQL vs. Oracle (not speed)Aron Pilhofer16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
            • RE: MySQL vs. Oracle (not speed)Aron Pilhofer16 Aug
              • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
            • Re: MySQL vs. Oracle (not speed)Mark Matthews16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
        • RE: MySQL vs. Oracle (not speed)Aron Pilhofer16 Aug
        • RE: MySQL vs. Oracle (not speed)Aron Pilhofer16 Aug
    • Re: MySQL vs. Oracle (not speed)Gelu Gogancea16 Aug
      • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
        • Re: MySQL vs. Oracle (not speed)Gelu Gogancea16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
  • Re: MySQL vs. Oracle (not speed)Anderson Pereira Ataides16 Aug
RE: MySQL vs. Oracle (not speed)Art Fore16 Aug
RE: MySQL vs. Oracle (not speed)John Griffin16 Aug
  • Re: MySQL vs. Oracle (not speed)Elizabeth Bogner17 Aug
Re: MySQL vs. Oracle (not speed)Heikki Tuuri16 Aug
RE: MySQL vs. Oracle (not speed)Alec.Cawley16 Aug
RE: MySQL vs. Oracle (not speed)John Griffin16 Aug
  • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
Re: MySQL vs. Oracle (not speed)Heikki Tuuri16 Aug
RE: MySQL vs. Oracle (not speed)Kenneth Hylton16 Aug
Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
  • RE: MySQL vs. Oracle (not speed)Mary Stickney17 Aug
RE: MySQL vs. Oracle (not speed)Steve Orr16 Aug
RE: MySQL vs. Oracle (not speed)Heikki Tuuri16 Aug