RE: SQL vs. traditional I/O?

[michaelr_41@xxxxxxxxxxxxxx]

None.

However, you can have as many angels dance as you wish.

On Fri, 23 Jul 2004 15:44:36 +1100, Frank.Kolmann@xxxxxxxxxx said:
> 
> 
> 
> 
> How many angles can dance on the head of a pin.
> How many angles can dance on the point of a pin.
> Does it matter. Early on I had some issues with SQLs
> performance.  As IBM improved SQLs optimiser and I
> understood the importance of permanent indexes I have
> had no problems with SQL.
> 
> Frank Kolmann
> >> From: Joe Pluta
> >>
> >> Results:
> >>
> >>             Start  End    Count
> >> Native I/O: 193459 193509 100000
> >> SQLRPGLE:   194230 194241 10000
> >
> >On advice, I added OPTIMIZE FOR 1 ROW to the SELECT.
> >Result?  No discernable change.  Still ten seconds fully optimized.
> >Joe
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
-- 
  
  michaelr_41@xxxxxxxxxxxxxx