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



If I remember, the 3rd run of the same statement results in some kind of
statement caching. Besides, the SQL resources are all in place.

At 04:41 PM 3/15/02 -0500, you wrote:

>Normally I would agree to running the debugger.  But my question is this:
>If I do see a performance suggestion, won't it be something like 'create an
>index-CPI432F'?  And I am not going to do that on a IBM supplied file.
>But I ran the debugger.
>
>select dbname
>from qsys2/syscolumns
>where dbname='DATDIVF'
>fetch first 1 row only
>Time=2 sec - not bad
>CPI432C - QSYS/QADBILLB  0
>CPI432F - DBIREL, DBILB2, DBIATR
>
>select count(*) from qsys2/syscolumns
>where dbname='DATDIVF'
>  and TBNAME between 'AAAAAAAAAA' and 'ZZZZZZZZZZ'
>  and NAME between  'AAAAAAAAAA' and 'ZZZZZZZZZZ'
>Time=55 sec
>CPI432C - QSYS/QADBILLB  0
>CPI432F - DBIREL, DBILB2, DBIATR, DBILFI, DBILFL
>
>I'll probably either bust this down into 2 sql's or 1 api call and 1 sql.
>
>Now for the weird part.  I ran several consecutive time trials.  I would
>signoff, signon, strdbg, strsql, and run the above statement.  After a
>couple of runs it got to be pretty fast.  Does it store a temporary access
>path that it uses, and does this path actually span jobs?
>
>
>Rob Berendt
>--
>"They that can give up essential liberty to obtain a little temporary
>safety deserve neither liberty nor safety."
>Benjamin Franklin
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.