Re: system performance

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Just for fun, another link is a presentation by Mark Holm, president or 
something of Centerfield Technology - and my former boss and Elvis' 
current boss. Lots of good advice on whether to use the larger page size 
for SQL indexes - it's not, apparently, always the better choice. Gotta 
love that answer - "It depends"

HTH
Vern

Jim Franz wrote:
> If you are doing any SQL or Query, I believe the sql engines will not use an 
> index if it has select/omit. That can cause the sql engine to have to build 
> it's own index to use.
> Jim Franz
>
> ----- Original Message ----- 
> From: "Lois Krake" <lkrake@xxxxxxxx>
> To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
> Sent: Saturday, August 29, 2009 9:36 AM
> Subject: system performance
>
>
>   
> > Hi:
> >
> > I am trying to do research on the impact on system performance using 
> > logicals with select-omit criteria(we do not use the DYNSLT keyword) vs. 
> > using if statements in the rpg code. I don't know if there is a 
> > performance difference but our system is slowing down & I am trying to 
> > find reasons. I believe they are the direct result of poor programming 
> > techniques & I am trying to identify them.
> >
> > Lois
> > --
> > This is the RPG programming on the IBM i / System i (RPG400-L) mailing 
> > list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> >
> >     
>
>