I don't think I'm missing the problem at all. You say processing the
temp table takes a long time, correct? There are two reasons it will
take a long time. First possibility is that actually reading the data is
where your time is at. Changing the initial query to sort the results in
the order the user expects them will prove or disprove that (it may also
make no difference, as long as it doesn't make it slower, I'd be
inclined to get rid of the temp table). Have you tried that before to
see if it improves run time? The second possibility is that the overhead
associated with CGIDEV2 is where all the time is at. I don't use it so I
can't offer you performance suggestions.
The other thing you can do is have the program log the time before and
after reads from the temp table and again at the end of your loop that
writes out each row so you can see if has anything at all to do with the
temp table.
Matt
-----Original Message-----
From: web400-bounces+matt.haas=cengage.com@xxxxxxxxxxxx
[mailto:web400-bounces+matt.haas=cengage.com@xxxxxxxxxxxx] On Behalf Of
Michael_Schutte@xxxxxxxxxxxx
Sent: Tuesday, October 30, 2007 1:27 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Faster HTML Output.
Again you guys are missing the real problem...
The problem is not the SQL statement. To clear it up.... The SQL
statement
is an INSERT into TempTable selecting from multiple tables. This
INSERT
executes in 4 seconds with a large amount of data...
The issue is reading the data dumped into the TempTable and outputting
it
to the HTML page. This morning, I read the first record as 8:26:00 and
read the last record at 8:27:09 from the TempTable.
NOTE: The SQL INSERT started at 8:25:56...
What I'm looking for is getting the data to the user without having to
read
through the TempTable on the iSeries, like an XML document. If I can do
an
SQL into an XML document. But I don't know where to begin with this.
The actual downloading of the built webpage, doesn't appear to take very
long, at least not for me.
Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
"The Secret's the Sauce! Enjoy our new Bob-B-Q Pulled Pork Knife & Fork
Sandwich!"
<matt.haas@cengag
e.com>
Sent by:
To
web400-bounces@mi <web400@xxxxxxxxxxxx>
drange.com
cc
Subject
10/30/2007 01:15 Re: [WEB400] Faster HTML Output.
PM
Please respond to
Web Enabling the
AS400 / iSeries
<web400@midrange.
com>
Sounds to me like you can skip them temp table by adding an ORDER BY
clause to your original query.
Matt
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Michael_Schutte@xxxxxxxxxxxx
Sent: Tuesday, October 30, 2007 1:11 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Faster HTML Output.
No to reduce the number of records. It's just a subset of records based
on
user selection.
The temp file is keyed.
Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
"The Secret's the Sauce! Enjoy our new Bob-B-Q Pulled Pork Knife & Fork
Sandwich!"
"albartell"
<albartell@gmail.
com>
To
Sent by: "'Web Enabling the AS400 /
web400-bounces@mi iSeries'" <web400@xxxxxxxxxxxx>
drange.com
cc
Subject
10/30/2007 01:01 Re: [WEB400] Faster HTML Output.
PM
Please respond to
Web Enabling the
AS400 / iSeries
<web400@midrange.
com>
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.
--
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
