Re: Faster HTML Output.

Not my place... this request is to be a report for them to print out.
Think of it this way. If a restaurant were to run this report from their
computer... they may want to print it. A "subfile" type of page will
require them to print every page manually. Also their printer is not
accessible by the as400.

I guess, I was hoping someone would say to a SELECT for XML and build an
xml document in which the html page will reference. I'm just not sure how
to go this route, because the user is also asking for break totals.


Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
"The Secret's the Sauce! Enjoy our new Bob-B-Q Pulled Pork Knife & Fork
Sandwich!"


web400-bounces@xxxxxxxxxxxx wrote on 10/30/2007 10:51:36 AM:

I agree - add paging to the browser display.

Think about how you would build a subfile. Show the user xx records on a
page, and give them a way to display the next page and the previous page.
(buttons?)

Leonard Hrabar
Senior Developer

Holy Name Hospital
718 Teaneck Road
Teaneck, NJ 07666
(201) 833-3000 ext: 5861

hrabar@xxxxxxxxxxxxxxxxx

"Bradley V.

Stone"

<bvstone@bvstools

To

.com> "Web Enabling the AS400 / iSeries"

Sent by: <web400@xxxxxxxxxxxx>

web400-bounces+hr

cc

abar=mail.holynam

e.org@xxxxxxxxxxx

Subject

m Re: [WEB400] Faster HTML Output.

10/30/2007 10:47

AM

Please respond to

Web Enabling the

AS400 / iSeries

<web400@midrange.

com>

Figure out if there's a reason the need 122 pages at once. If not, add
paging.

I know sometimes users "need" that sort of thing. But sometimes it's

easy

to show them a better way. Imagine if ebay showed you every auction that
matched your search on one page... :)

Bradley V. Stone
BVSTools - www.bvstools.com
eRPG SDK - www.erpgsdk.com

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx

[mailto:web400-bounces@xxxxxxxxxxxx]On

Behalf Of Michael_Schutte@xxxxxxxxxxxx
Sent: Tuesday, October 30, 2007 9:22 AM
To: web400@xxxxxxxxxxxx
Subject: [WEB400] Faster HTML Output.



I need some ideas. We are currently using CGIDEV2 for building our web
applications. In this particular program, I have an SQL statement that
inserts a large amount of data into a TEMP table and it runs in under 4
seconds. However, reading through the temp table and building the HTML
page takes over a minute. FYI, the result is a 122 printed web page.
Typically, a user wouldn't be asking for this large amount of data,
however, the user is requesting to have this capability.

Does anyone have any ideas on how to improve the speed? Can anyone

point

me in any direction?



Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
"The Secret's the Sauce! Enjoy our new Bob-B-Q Pulled Pork Knife & Fork
Sandwich!"

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.



--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.