Look at using a User Index for the temp area instead maybe? Or maybe skip
the temp file all together by doctoring up your SQL statement to give what
you need. What is the reason for going to the temp file? A sort?
HTH,
Aaron Bartell
http://mowyourlawn.com
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Michael_Schutte@xxxxxxxxxxxx
Sent: Tuesday, October 30, 2007 11:07 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Faster HTML Output.
Again, my issue is with reading the data. 1 minute to read the whole temp
table. I was thinking if I would do an SQL insert into an XML document
would speed this process up since the sql statement runs in 4 seconds.
Michael Schutte
Admin Professional
"The Secret's the Sauce! Enjoy our new Bob-B-Q Pulled Pork Knife & Fork
Sandwich!"
Mike Cunningham
<mcunning@xxxxxxx
> To
Sent by: Web Enabling the AS400 / iSeries
web400-bounces@mi <web400@xxxxxxxxxxxx>
drange.com cc
Subject
10/30/2007 12:02 Re: [WEB400] Faster HTML Output.
PM
Please respond to
Web Enabling the
AS400 / iSeries
<web400@midrange.
com>
How do you do this? "Configure the deflate module to compress the HTML
output stream."
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Jones, John (US)
Sent: Tuesday, October 30, 2007 11:46 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Faster HTML Output.
From a non-data perspective:
Configure the deflate module to compress the HTML output stream. Will
definitely reduce bandwidth which should improve response time for actually
sending the generated page out. There is a slight bit of CPU associated
with this but I've never noticed it being significant enough to worry about.
Most folks consider the CPU/bandwidth tradeoff to overall lead to better
response times, although YMMV.
If you run SSL consider a hardware Crypto card to offload SSL from the CPU.
Apply the latest HTTP server PTFs and the HIPER & DB2 groups. Apply other
performance-related PTFs.
--
John A. Jones, CISSP
Senior Analyst, Global Information Security Jones Lang LaSalle, Inc.
tel: +1-630-455-2787 fax: +1-312-601-1782 john.jones@xxxxxxxxxx
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Jeff Day
Sent: Tuesday, October 30, 2007 9:32 AM
To: web400@xxxxxxxxxxxx
Subject: Re: [WEB400] Faster HTML Output.
to speed up the read, make sure the keys on the file are the same as the
keys you use to read the file.
<Michael_Schutte@xxxxxxxxxxxx> 10/30/07 10:21 AM >>>
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 message has been scanned for viruses by MailControl -
www.mailcontrol.com
Click
https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== to report
this email as spam
--
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 email is for the use of the intended recipient(s) only. If you have
received this email in error, please notify the sender immediately and then
delete it. If you are not the intended recipient, you must not keep, use,
disclose, copy or distribute this email without the author's prior
permission. We have taken precautions to minimize the risk of transmitting
software viruses, but we advise you to carry out your own virus checks on
any attachment to this message. We cannot accept liability for any loss or
damage caused by software viruses. The information contained in this
communication may be confidential and may be subject to the attorney-client
privilege. If you are the intended recipient and you do not wish to receive
similar electronic messages from us in the future then please respond to the
sender to this effect.
--
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.
midrange.com
