Re: Faster HTML Output.

["Dave Odom" <Dave.Odom@xxxxxxxxxxxx>]

Sounds like you might be using the wrong tool to do the job.  It would appear the user's requirement is more suited to a GUI query tool available via the Web.   I'd look into QMF for Windows/Websphere, now called Dataquant or WebQuery.   HTML is not a query reporting tool.
 
Sincerely,
 
David Odom
Arizona

> > > "Charlie Ramsdale" <Charlie_Ramsdale@xxxxxxxxxxx> 10/30/2007 08:11 >>>
If you break it down to paging, using the print key would print the
current page for a quick, limited print.
Then you can add a 'print' button to allow printing of all records (as
you do now).  Best of both worlds.


-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] 
On Behalf Of Michael_Schutte@xxxxxxxxxxxx 
Sent: Tuesday, October 30, 2007 10:01 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Faster HTML Output.

Not my place... this request is to be a report for them to print out.
Think of it this way.  If a restaurant were to run this report from
their
computer... they may want to print it.  A "subfile" type of page will
require them to print every page manually.  Also their printer is not
accessible by the as400.

I guess, I was hoping someone would say to a SELECT for XML and build an
xml document in which the html page will reference.  I'm just not sure
how
to go this route, because the user is also asking for break totals.


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:51:36 AM:

> I agree - add paging to the browser display.
>
> Think about how you would build a subfile. Show the user xx records on
a
> page, and give them a way to display the next page and the previous
page.
> (buttons?)
>
> Leonard Hrabar
> Senior Developer
>
> Holy Name Hospital
> 718 Teaneck Road
> Teaneck, NJ 07666
> (201) 833-3000  ext: 5861
>
> hrabar@xxxxxxxxxxxxxxxxx 

>              "Bradley V.

>              Stone"

>              <bvstone@bvstools
To
>              .com>                     "Web Enabling the AS400 /
iSeries"

>              Sent by:                  <web400@xxxxxxxxxxxx>

>              web400-bounces+hr
cc
>              abar=mail.holynam

>              e.org@xxxxxxxxxxx 
Subject
>              m                         Re: [WEB400] Faster HTML
Output.

>

>

>              10/30/2007 10:47

>              AM

>

>

>              Please respond to

>              Web Enabling the

>               AS400 / iSeries

>              <web400@midrange.

>                    com>

>

>

> Figure out if there's a reason the need 122 pages at once.  If not,
add
> paging.
>
> I know sometimes users "need" that sort of thing.  But sometimes it's
easy
> to show them a better way.  Imagine if ebay showed you every auction
that
> matched your search on one page...  :)
>
> Bradley V. Stone
> BVSTools - www.bvstools.com 
> eRPG SDK - www.erpgsdk.com 
>
> > -----Original Message-----
> > From: web400-bounces@xxxxxxxxxxxx 
[mailto:web400-bounces@xxxxxxxxxxxx]On 
> > Behalf Of Michael_Schutte@xxxxxxxxxxxx 
> > Sent: Tuesday, October 30, 2007 9: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.
>
>
>
> --
> 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.