• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

major slowdown with new production install

 
m winzenburg
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Help! We are having a MAJOR performance problem with a new installation of production code at our company. Our new code is taking 4 times longer than in the past. What our code does is read in from a flat file, parse out the data (doing various things to it) and then update a DB/2 database. At first we thoughtit might be due to the additional I/O (database calls), but we've reduced this to a minimum by restructuring our code, and it hasn't made a difference in the performance time. Since this installation involved new fields added to the database, we've made sure our DBAs have done some re-orgs and also put some indexes in place. This did speed things up a bit, but we're still running slow enough to be in crisis. Can anyone give us some ideas of things to check? Would java memory be a factor?
 
Ilja Preuss
author
Sheriff
Posts: 14112
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The possibilities are manifold. I think you need to use a profiler to find the bottleneck(s).
 
m winzenburg
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We were wondering what you meant by a profiler. I'm assuming you mean a type of software that can run diagnostics? Any suggestions?
 
Jim Bedenbaugh
Ranch Hand
Posts: 171
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by m winzenburg:
We were wondering what you meant by a profiler. I'm assuming you mean a type of software that can run diagnostics? Any suggestions?

Use JProbe. You can download a trial version and use it. I would recommend buying a licensed copy - you'll need it again someday.
[ July 30, 2003: Message edited by: Jim Bedenbaugh ]
 
David Weitzman
Ranch Hand
Posts: 1365
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A profiler will help you identify which methods take the longest time to run or are run most frequently, which is vital information for improving performance. Check out the google directory for a few options.
 
Ilja Preuss
author
Sheriff
Posts: 14112
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We are using JProfiler - works well.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic