Re: Slow Query Performance from the Web

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

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