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

I don't have a choice.... as to what database I use.... I WISH I did

and I didnt design the tables, I inherited them....
BUT I can do SOME redesign, but only by creating new tables.
I have to leave all the old tables as is , for the old stuff.


see my hands are tied behind my back.


-----Original Message-----
From: Gelu Gogancea [mailto:ggelu@stripped]
Sent: Friday, August 16, 2002 1:48 PM
To: Mary Stickney; Elizabeth Bogner; mysql@stripped
Subject: Re: MySQL vs. Oracle (not speed)


Hi Mary,

My opinion:
MySQL forums are open to every one to said about him MySQL
problems,experience... etc.From performance point of view(slow query), 90 %
from the people which was posted on this forums , has problem with Database
and Table design.Comparing RDBMS it's not quite fairly because every of them
have advantage and disadvantage.But you must BE ABLE TO CHOICE DEPENDS ON
WHAT YOU NEED(or customer).
Like project manager when you begin to develop a database software must
know:
-ALL ABOUT RDBMS WHICH WISH TO USE(Apropos...MySQL have a too complex set of
SQL commands).
-How big database will be in the future?
-From time to time what Upgrade must to do on the Hardware?
-If is a multi level application, in every level you must know what
programming language you must used (style or technic of programming)
...and WHAT IS MOST IMPORTANT :

HOW YOU IMPLEMENTED (...AND WHAT TEST YOU MUST MAKE TO....) THE ENTIRE
SOFTWARE TO WORK WITH NO PROBLEM ?

Why i mentioned about this thinks(and are not too many) ?...because the
table "admincoverage" it seem is not pass by NORMALIZATION RULE STEP 1.

You have this fields :

AccidentElim smallint(6)   ,
AccidentElimUnitID varchar(5)   ,
SicknessElim smallint(6)   ,
SicknessElimUnitID varchar(5)   ,
AccidentBenefit double   ,
AccidentBenefitUnitID varchar(5)   ,
SicknessBenefit double   ,
SicknessBenefitUnitID varchar(5)   ,

.... in this example i iterate only 2 entity of data from one table.But i
think you have more than that.Usually in this situation you must create one
table for one entity of data and make relations between entity(tables) using
FOREIGN KEYS.MySQL support (and work very well) and SCHEMA OF INDEXES.

What convince me is the next sequence of query :

"INNER JOIN AdminCoverage ON
AdminHierarchy.CoverageID=AdminCoverage.CoverageID AND
AdminHierarchy.CoverageIDSbc=AdminCoverage.CoverageIDSbc" & _

I suppose you don't need by a double confirmation.

I'm sorry if something from what i said...was not what you expected.My
intention is to help...and finally it's only my opinion.

Best Regards and Good luck (you need),

Gelu

____________________________________________________
G.NET SOFTWARE COMPANY

Permanent e-mail address : gg@stripped
                                          gelugogancea@stripped

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