Where is the data coming from that is populating this large SQL INSERT
statement?
I don't think we have been given enough of the picture to give solid
solutions back to you. In reality, depending on a number of variables, you
should be able to easily deliver this dataset back to the browser in less
than a second.
Aaron Bartell
http://mowyourlawn.com
-----Original Message-----
From: web400-bounces+albartell=gmail.com@xxxxxxxxxxxx
[mailto:web400-bounces+albartell=gmail.com@xxxxxxxxxxxx] On Behalf Of
Michael_Schutte@xxxxxxxxxxxx
Sent: Tuesday, October 30, 2007 12: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!"
midrange.com
