Re: Faster HTML Output.

[<matt.haas@xxxxxxxxxxx>]

So there's the first problem to solve. There are two big picture things
to look at with processing this table. #1 is how much time does it take
to actually read the data? #2 is how much time does CGIDEV2 take to
render the page?

Based on your other email, it seems like HTML may be the wrong solution
for this problem. Since it is a report they are after, generating a PDF
and emailing it to them may be a better solution.

Matt

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Michael_Schutte@xxxxxxxxxxxx
Sent: Tuesday, October 30, 2007 10:50 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Faster HTML Output.

It's actually 1 minute to read through the whole temp table.  I've timed
it. by outputting timestamps in the html page.


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:46:04 AM:

> Where is it slow? 122 pages is a lot of HTML to return. I would
suspect
> that no matter how fast the server side is, a lot of time is going to
be
> spent sending the data to the browser and the browser rendering it.
>
> Matt
>
> -----Original Message-----
> From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
> On Behalf Of Michael_Schutte@xxxxxxxxxxxx
> Sent: Tuesday, October 30, 2007 10: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.