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
