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?

 

[Oregon48]

Hi Ted,
Try this. With the query open in design view, cursor in the grey area around tables, right click and choose properties. There is an ODBC timeout setting which is set to 60 seconds, change to 0 zero. Hope it helps
Alan