List:General Discussion« Previous MessageNext Message »
From:Mary Stickney Date:August 16 2002 2:56pm
Subject:RE: MySQL vs. Oracle (not speed)
View as plain text  
it has been sent to the list.... but here it is again

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: Tom Gao [mailto:tomgmisc@stripped]
Sent: Friday, August 16, 2002 9:22 AM
To: mysql@stripped
Subject: Re: MySQL vs. Oracle (not speed)


what query was it may I ask ?

Tom
----- Original Message -----
From: "Mary Stickney" <mary.stickney@stripped>
To: "Francisco" <frsgti@stripped>; "Elizabeth Bogner"
<elizabeth.bogner@stripped>; <mysql@stripped>
Sent: Friday, August 16, 2002 11:52 PM
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-tomgmisc=optushome.com.au@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-thread117324@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-mary.stickney=tagtmi.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