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.



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.