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

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


...in this case...is very "sad".
You use this query to generate report or it's for usually work ?

_____________________________________________________
G.NET SOFTWARE COMPANY

Permanent e-mail address : gg@stripped
                                          gelugogancea@stripped
----- Original Message -----
From: "Mary Stickney" <mary.stickney@stripped>
To: "Gelu Gogancea" <ggelu@stripped>; "Elizabeth Bogner"
<elizabeth.bogner@stripped>; <mysql@stripped>
Sent: Friday, August 16, 2002 9:58 PM
Subject: RE: MySQL vs. Oracle (not speed)


>
>
> 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