Performance Issue

[TedRush]

Overview: Our company recently purchased a vendor application that was configured and installed by a 3rd party reseller. Our back end database is Oracle on a Win2000 server. The application is in Java on a Win2000 server running IIS. This is a low transaction Intranet app. PCs are XP.

Situation: The first few data queries are very slow (20-40) seconds. After a few queries the response time is very fast, one second or less.

Problem: After 60 seconds of inactivity, the cache is lost and performance reverts back to the slow (20-40) second response time. Increasing ObjectCacheTTL did not help.

Any advice?

 

[palbano]

>> Increasing ObjectCacheTTL did not help.

It sounds like you have some database connection pool component and the timeout is set to one minute. Unless that’s what that is I can see why it didn’t help.

You need to find out how to increase the database connection pool timeout. It might be a feature of your database or perhaps a JDBC specific add on component from your vender or even a third party library.

There are several database connection pools freely available and it’s not even that difficult to develop your own. Do you know anything about how you are pooling connections?


-pete

 

[TedRush]

Pete,
Thanks for your input & advice. I don't know how the pooling connection but I'll follow your lead & check into it.

Thanks again.

Ted