RE: SQL vs. traditional I/O? -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.