List:General Discussion« Previous MessageNext Message »
From:Mary Stickney Date:August 16 2002 3:08pm
Subject:RE: MySQL vs. Oracle (not speed)
View as plain text  
speed is of the utmost importance ,
I can't have a client run a report and wait 2 days for it to finish.


-----Original Message-----
From: Aron Pilhofer [mailto:aronpilhofer@stripped]
Sent: Friday, August 16, 2002 9:46 AM
To: Mary Stickney; aronpilhofer@stripped; Francisco; Elizabeth Bogner;
mysql@stripped
Subject: RE: MySQL vs. Oracle (not speed)


Well, I meant this to be off-list (thus the next message) because I don't
want to start a round of M$ bashing, blah, blah...

But since I blew it already, I don't mean to sound harsh or defensive,
because, frankly, I don't have a vested interest one way or the other which
db you use. And I'm not doubting your results.

I'm simply saying you should probably look at your settings/configuration
because MySQL should not be lagging that far behind SQL Server. That is
unless there is something particularly unique about your setup or tables or
data that is causing queries to run so slowly on MySQL.

If speed is important to you (and it sounds like it is) then it might be
worth tweaking some to figure out what is causing MySQL to lag so badly.

Ok, 'nuff said.

aron


> -----Original Message-----
> From: Mary Stickney [mailto:mary.stickney@stripped]
> Sent: Friday, August 16, 2002 10:36 AM
> To: aronpilhofer@stripped; Francisco; Elizabeth Bogner;
> mysql@stripped
> Subject: RE: MySQL vs. Oracle (not speed)
>
>
>
> no need to get defensive ...
>
> We did do a timed test.
>
> I am trying to sped up a program that currently take over 12
> hours to run...
> I started running it yesterday morning and it is still going. and
> going and
> going...
>
>
>
>
>
> -----Original Message-----
> From: Aron Pilhofer [mailto:aronpilhofer@stripped]
> Sent: Friday, August 16, 2002 9:25 AM
> To: Mary Stickney; Francisco; Elizabeth Bogner; mysql@stripped
> Subject: RE: MySQL vs. Oracle (not speed)
>
>
> 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
>


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