List:General Discussion« Previous MessageNext Message »
From:Mary Stickney Date:August 16 2002 3:31pm
Subject:RE: MySQL vs. Oracle (not speed)
View as plain text  
explian returns this

;table;type;possible_keys;key;key_len;ref;rows;Extra
;table;type;possible_keys;key;key_len;ref;rows;Extra
;AdminCoverage;range;CoverageID,CoverageIdSbc,InitPremDateIndex,CovIdCovIdSb
cIndex,CovIdCovIdSbcInitPremIndex;InitPremDateIndex;3;;315663;where used;
Using temporary; Using filesort
;AdminHierarchy;ref;CoverageIDIndex,CoverageIdSbcIndex,CovIdCovIdSbcIndex;Co
vIdCovIdSbcIndex;25;AdminCoverage.CoverageID,AdminCoverage.CoverageIdSbc;7;w
here used
;AdminProducer;ref;ProducerIDIndex;ProducerIDIndex;15;AdminHierarchy.Writing
AgentID;11;
;AdminProduct;ref;ProductIdIndex;ProductIdIndex;15;AdminCoverage.ProductId;1
1;
;tempsap;ALL;;;;;10019;

-----Original Message-----
From: Jocelyn Fournier [mailto:joc@stripped]
Sent: Friday, August 16, 2002 10:21 AM
To: Mary Stickney; Francisco; Elizabeth Bogner; mysql@stripped
Subject: Re: MySQL vs. Oracle (not speed)


Hi,

Which columns are indexed in your table ?
What does EXPLAIN into MySQL return ?

Regards,
  Jocelyn
----- Original Message -----
From: "Mary Stickney" <mary.stickney@stripped>
To: "Francisco" <frsgti@stripped>; "Elizabeth Bogner"
<elizabeth.bogner@stripped>; <mysql@stripped>
Sent: Friday, August 16, 2002 4:31 PM
Subject: RE: MySQL vs. Oracle (not speed)


>
> I am not for one or the other,,,, I just hate to wait....
> I need speed...
>
> we already have a MS-SQL server , so no more money needs to me spent...
>
> I did a 4 table join , drwing 3 years of sales data
>
> table one 6.5 million records  --- AdminHierarchy
> table two 1.5 million records ---- AdminCoverage
> table three 10191 records  ------- AdminProcuder
> table four  19823 records  ------- AdminProduct
>
> SELECT AdminHierarchy.WritingAgentID, AdminHierarchy.WritingAgentSlot,
> AdminHierarchy.ProducerID,
> tempsap.taxid, (ModalPremium * BillModeID * (PercentOfCase / 100)) AS
> TotalPaidPremium,
> AdminCoverage.CoverageID, AdminCoverage.CoverageIDSbc,
> AdminHierarchy.RegionCode,
> AdminProduct.LobId, AdminCoverage.StatusID, AdminCoverage.StatusDate,
> AdminCoverage.InitialPremiumDate, AdminCoverage.PaidToDate,
tempsap.GROUPID
> FROM AdminHierarchy
> INNER JOIN AdminCoverage ON
> AdminHierarchy.CoverageID=AdminCoverage.CoverageID
> AND AdminHierarchy.CoverageIDSbc=AdminCoverage.CoverageIDSbc
> LEFT JOIN AdminProducer ON
> AdminProducer.ProducerID=AdminHierarchy.WritingAgentID
> LEFT JOIN AdminProduct ON AdminCoverage.ProductID=AdminProduct.ProductID
> Left join tempsap on AdminProducer.taxid = tempsap.taxid
> WHERE AdminCoverage.InitialPremiumDate >= '20000101' AND
> AdminCoverage.InitialPremiumDate <= '20020430'
> ORDER BY AdminHierarchy.WritingAgentSlot,AdminCoverage.CoverageId,
> AdminCoverage.CoverageIdSbc,
> AdminHierarchy.ProducerID
>
>
>
> -----Original Message-----
> From: Francisco [mailto:frsgti@stripped]
> Sent: Friday, August 16, 2002 9:21 AM
> To: Mary Stickney; Elizabeth Bogner; mysql@stripped
> Subject: RE: MySQL vs. Oracle (not speed)
>
>
> Hi Mary,
>
> I am not specially against or pro MySQL, Microsoft SQL
> Server, Oracle or any other database. Teams make their
> choices based on the project needs such as budget (is
> your team ready to spend thousands of dollars on
> Oracle and marry that corporation forever?),
> deployment (do you want your product with Oracle's
> price tag attached to it?), functionality: does the
> database server provide a viable solution technically
> speaking?, etc, etc. So it is not an issue of good or
> bad.
>
> But regardless of all that, what we should have, at
> least, is a great respect for people that has been
> working so hard to provide an affordable and viable
> alternative to the database server giants. I don't
> think that throwing those numbers without any other
> explanations about your test environments, SQL,
> tables, etc is a good practice. Do you think that you
> always get what you pay when you spend thousand of
> dollars in software and services without leaving you
> any other choices?
>
> I know that you did not put bad intentions behind your
> comment but should be more careful and precise.
>
> Whoever is interested on some benchmarks can go to:
> http://www.mysql.com/information/benchmarks.html
>
> There is an interesting article comparing Ms-SQL,
> Oracle, DB2 and MySQL in:
> http://www.pcmag.com/article2/0,4149,7279,00.asp
>
> Sincerely,
>
> Francisco
>
> --- Mary Stickney <mary.stickney@stripped> wrote:
> >
> > 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
> >
>
>
> __________________________________________________
> 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-thread117331@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-joc=presence-pc.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