Re: Slow Query Performance from the Web

["Brad Stone" <brad@xxxxxxxxxxxx>]

Here we go..   start preaching the doom and gloom to scare
us to spend money.

If what you say is true, it would have already happened.


On Wed, 19 Apr 2006 11:58:09 -0700
 "Dave Odom" <Dave.Odom@xxxxxxxxxxxx> wrote:
> And if you embrace that, it assures the System i5
> (iSeries), will go the
> way of OS/2, BETA, etc. 
> 
> But, IF and ONLY IF, System i5 applications are
> modernized like IBM and
> I are trying to get folks to do for most of their legacy
> 5250 apps, the
> System i5 MIGHT, JUST MIGHT be seen by the rest of the IT
> world as a
> platform and OS to think about when spending their large
> dollars.  
> Right now, most of the IT world, says:  "System iWhat" or
> "iWhatSeries".
>  And when you say "green screen" they laugh because they
> know how
> outdated your apps are.
> 
> Now, it is true many Java apps are slow, but that is
> usually about how
> they are designed or configured AND/OR how the database
> is designed.   
> 
> I sure how the System i5 community can change and get
> away from its
> mind set about the green screen and CL and RPG and
> modernize because it
> is such great hardware and OS.
> 
> Sincerely,
> 
> David Odom
> 
> >>> tehuff@xxxxxxxxxxxxx 4/19/2006 08:04:35 >>>
> 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.
> 
> -- 
> 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