RE: SQLRPGLE - Load-Up question...

[dmosley@xxxxxxxxxx]

Where exactly are you talking about me adding the 'optimize' status.  I'm
not using a SELECT statement, I'm using a PREPARE and FETCH combo...

David L. Mosley, Jr.
Systems Analyst
2000 CentreGreen Way
Suite 250
Cary, NC 27513



                    "Smith, Mike"
                    <Mike_Smith@RGCReso        To:     
"'rpg400-l@midrange.com'" <rpg400-l@midrange.com>
                    urces.com>                 cc:
                    Sent by:                   Subject:     RE: SQLRPGLE - 
Load-Up question...
                    rpg400-l-admin@midr
                    ange.com


                    05/22/02 01:20 PM
                    Please respond to
                    rpg400-l






What Buck says makes a lot of sense and should be heeded, however, I would
still consider placing this on your select.  It won't make much difference
if the file is small, but it will make a Huge difference when the file is
large.

Just append the 'optimize' statement to the end of your sql statement.  I
use 'X' as the subfile page size.



-----Original Message-----
From: dmosley@dancik.com [mailto:dmosley@dancik.com]
Sent: Wednesday, May 22, 2002 1:17 PM
To: rpg400-l@midrange.com
Subject: RE: SQLRPGLE - Load-Up question...



No, I'm not too familiar with using the "Optimize for x rows".  I don't
think that the delay begins within the first SQL command.  (I think)

I do compile them with the parameter "Allow copy of data" ALWCPYDTA(*YES),
rather than *OPTIMIZE. I had read a while back that this would help, by
retrieving 4% of the results.  (something like that). It definitely cuts
the
time down.

David L. Mosley, Jr.
Systems Analyst
2000 CentreGreen Way
Suite 250
Cary, NC 27513



                    "Smith, Mike"
                    <Mike_Smith@RGCReso        To:
"'rpg400-l@midrange.com'" <rpg400-l@midrange.com>
                    urces.com>                 cc:
                    Sent by:                   Subject:     RE: SQLRPGLE -
Load-Up question...
                    rpg400-l-admin@midr
                    ange.com


                    05/22/02 12:58 PM
                    Please respond to
                    rpg400-l






David
Do you have an 'Optimize for x rows' on your select statement?

-----Original Message-----
From: dmosley@dancik.com [mailto:dmosley@dancik.com]
Sent: Wednesday, May 22, 2002 12:36 PM
To: rpg400-l@midrange.com
Subject: SQLRPGLE - Load-Up question...



I've created several SQLRPGLE service programs that are used for display
files into subfiles. No, problem. However, the very first time of entering
the program, there is a delay of several seconds more than a normal RPGLE
program would have. I'm guessing that it is the SQL-stuff loading up. (Not
sure of the proper terminology, don't kill me).

Is there a way to shrink this time down.  After the first entry, is ok. SQL
activation groups are all still active, and the program flies right
into action.  It's just that first time, that sucks.   Also, these same
service programs are used for loading up HTML, and the load-up time on that
is even longer. It's hard to sell the idea of SQLRPGLE objects, when right
off the bat, the
user experiences a delay.   First impressions are hard to get past..

thanks
dav


David L. Mosley, Jr.
Systems Analyst
2000 CentreGreen Way
Suite 250
Cary, NC 27513

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com To subscribe, unsubscribe,
or
change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com To subscribe, unsubscribe,
or
change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.




_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com To subscribe, unsubscribe,
or
change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.