Re: Slow Query Performance from the Web

["Brad Stone" <brad@xxxxxxxxxxxx>]

Seconded!  And CGI..  Just as fast as green screen.  :)

Brad
www.bvstools.com

On Wed, 19 Apr 2006 08:04:35 -0700
 "Tom Huff" <tehuff@xxxxxxxxxxxxx> wrote:
> Long Live Green Screen
> 
> -----Original Message-----
> From: web400-bounces@xxxxxxxxxxxx
> [mailto:web400-bounces@xxxxxxxxxxxx] On
> Behalf Of Walden H. Leverich
> Sent: Wednesday, April 19, 2006 7:36 AM
> To: Web Enabling the AS400 / iSeries
> Subject: Re: [WEB400] Slow Query Performance from the Web
> 
> Can you post the SQL and the number of rows returned in
> the result set?
> Also, have you run SQL Performance Monitors on the job?
> 
> One mistake I've seen lots of people make in Java is not
> to pre-size a
> collection when loading records into a collection. In one
> case simply
> adding an ensurecapacity(500) method call to an ArrayList
> changed
> response time from 20 seconds to sub-second.
> 
> The more memory constrained the app server the more a
> problem like this
> will be noticed.
> 
> -Walden
> 
> -- 
> Walden H Leverich III
> Tech Software
> (516) 627-3800 x3051
> WaldenL@xxxxxxxxxxxxxxx
> http://www.TechSoftInc.com
> 
> Quiquid latine dictum sit altum viditur.
> (Whatever is said in Latin seems profound.)
> 
> 
> -----Original Message-----
> From: web400-bounces+waldenl=techsoftinc.com@xxxxxxxxxxxx
>
[mailto:web400-bounces+waldenl=techsoftinc.com@xxxxxxxxxxxx]
> On Behalf
> Of Corissa Andrascik
> Sent: Tuesday, April 18, 2006 6:23 PM
> To: web400@xxxxxxxxxxxx
> Subject: [WEB400] Slow Query Performance from the Web
> 
> Hi All, 
>  
>  I'm new to this list - and I'm not sure this is the
> proper place to be
> asking this question - but I'd appreciate any direction
> you can give. 
>  
> We have a query that runs over a view that joins together
> several
> related physical files. We created indexes for each
> physical based on
> the Where clause in the query and when I run it through
> STRSQL on the
> 400 - the performance is good - about 8-9 seconds.   When
> the same query
> is passed from the web - we're running websphere on
> Window 2003 boxes -
> it takes in the neighborhood of 1 minute 10 seconds.  
>  
>   We are trying to figure out what can be done to
> optimize it from the
> web.  I realize I'm probably not giving enough
> information here - I just
> have no clue where to start!  If any of you have any
> ideas I'd be
> eternally grateful.
>  
> Thanks
> --
> 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.
> 

Bradley V. Stone
BVS.Tools
www.bvstools.com