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