Oracle

Slow processing

Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2007

Posts: 34

Reputation: chicago1985 is an unknown quantity at this point

Solved Threads: 0

chicago1985 chicago1985 is offline

Offline

Light Poster

Slow processing

Jun 24th, 2008

I have a JSP that works with an Oracle 9i database.

On my local windows workstation (using Tomcat) where I developed the JSP the application processes very quickly working with the Oracle database. The JSP application on the Production Intranet web server (Tomcat) connecting to the same Schema processes very slow many times during the day.

There is only one user for the application and I dont understand why the same application using the same database runs so much slower on the production server compared to my local workstation.

Please advise?

•

Join Date: Nov 2004

Posts: 6,143

Reputation: jwenting is just really nice

Solved Threads: 212

jwenting

Offline

duckman

Re: Slow processing

Jun 25th, 2008

hard to say. Network problems, poorly configured connection pools, poorly written code that doesn't release database connections (most likely).

As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.

•

Join Date: Feb 2007

Posts: 2,094

Reputation: debasisdas will become famous soon enough

Solved Threads: 128

debasisdas debasisdas is offline

Offline

Postaholic

Re: Slow processing

Jun 25th, 2008

That might be because of some network issue. this is only my guess.

Share your Knowledge.

•

Join Date: Nov 2007

Posts: 34

Reputation: chicago1985 is an unknown quantity at this point

Solved Threads: 0

chicago1985 chicago1985 is offline

Offline

Light Poster

Re: Slow processing

Jun 25th, 2008

•

Originally Posted by jwenting

hard to say. Network problems, poorly configured connection pools, poorly written code that doesn't release database connections (most likely).

Thanks, the interesting part it always lightning fast speed on my local workstation and on some days like today it is fast on the Production server even when I have many hits on it today. On other days it is slow on the Production server but again very quick on my local workstation every day. Still could be poorly written database connection or Network issue?