Re: Faster HTML Output.

["Raul A. Jager W." <raul@xxxxxxxxxx>]

I don't think it is a good idea to build an index that will be used only 
once.
It will be better to add "ORDER BY" in the SQL that populates the table, 
or use SQL to read the temp.


Michael_Schutte@xxxxxxxxxxxx wrote:

> The reason for using the temp table is a pretty big one.    We do not do
> logical DDS joins in our shop.  The ordering the user wants is over fields
> in multiple files.   So as I stated, I'm creating a temp table, then
> creating indexes over that empty temp table, then executing the select into
> that temp table.  BTW, the user is wanting to sort the data one of three
> ways.
>
> If you can read through a cursor faster than regular I/O please inform me,
> cuz as I see it... I still have to loop the same amount of times.
>
> Also, I was always thought, you'd get better execute time when you select
> the data you need from large tables into a temp table.
>
>
> Michael Schutte
> Admin Professional
> Bob Evans Farms, Inc.
> 3776 South High Street, Columbus, OH 43207
> Phone: 614/492-7419    Fax: 614/409-2017
> Visit us on the web! www.bobevans.com
>
> (Embedded image moved to file: pic00153.gif)
>
> "The Secret's the Sauce! Enjoy our new Bob-B-Q Pulled Pork Knife & Fork
> Sandwich!"
>
>
> web400-bounces@xxxxxxxxxxxx wrote on 10/31/2007 09:26:15 AM:
>
>  
>
> > Many of us have lived in this space a looong time - don't assume that we
> > haven't heard your request, we are just digging deeper because we don't
> >    
> like
>  
>
> > your current implementation (i.e. temp file) which many of us believe
> >    
> could
>  
>
> > potentially be eliminated.
> >
> >    
> >
> > > Cursor read or regular I/O doesn't make a difference.
> > >      
> > Could make all the difference.
> >
> >
> >    
> >
> > > For some reason, I thought that in V5R4, or another version, you were
> > >      
> > given the ability to do a SELECT ... FOR XML
> >
> > I have heard of this feature in some of the WebSphere/Rational SQL
> >    
> tooling,
>  
>
> > but have not used it.  I don't believe it is part of i5OS but instead a
> >    
> set
>  
>
> > of Java .jar files that offer the functionality.
> >
> > Aaron Bartell
> > http://mowyourlawn.com
> >
> > -----Original Message-----
> > From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
> > Behalf Of Michael_Schutte@xxxxxxxxxxxx
> > Sent: Wednesday, October 31, 2007 7:26 AM
> > To: Web Enabling the AS400 / iSeries
> > Subject: Re: [WEB400] Faster HTML Output.
> >
> > It helps with getting it off the server faster and puts the burden on the
> > client's computer.  Has I have said and some of you guys keep
> >    
> forgetting...
>  
>
> > the problem is not getting the data with the SQL statement.  The problem
> >    
> is
>  
>
> > reading the large amount of data.  So to use the suggestion of "not"
> >    
> using
>  
>
> > the temp table doesn't help.  Cursor read or regular I/O doesn't make a
> > difference.
> >
> > For some reason, I thought that in V5R4, or another version, you were
> >    
> given
>  
>
> > the ability to do a SELECT ... FOR XML (or something similar to that).
> >    
> But
>  
>
> > I haven't found any documentation on it.
> >
> >
> > 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.
> >