Win a copy of Practical SVG this week in the HTML/CSS/JavaScript forum!
    Bookmark Topic Watch Topic
  • New Topic

Oracle data fetch delay

Makesh Kumar Ramakrishnan
Ranch Hand
Posts: 88
  • Mark post as helpful
  • send pies
  • Report post to moderator
We are facing significant delay in loading the screen. Most of the delay time is due to data fetching(JDBC) time.

It's a swing application with Oracle 10i database. It's used by our 3 plants in different locations.Database is located at Arizona.
Three plant locations are Arizona,New Mexico and Ohio.

There is no delay in loading the screen for the users accessing from Arizona and New Mexico plants.It takes 4 secs to load the screen. This is expected as there are more data and lot of screen components to load.

But the users in Ohio plant are having problem. It takes 30 secs to load the same screen. The time break up shows that most of the delay is in fetching the data.

What are my options to fix this problem?

Note: We had similar problem in New Mexico plant. But it was solved. I used setFetchSize() function to fix this.

I appreciate your help.


Database: Oracle 10i
Java : Java 5
JDBC and Oracle thin driver

Jeanne Boyarsky
author & internet detective
Posts: 35757
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Report post to moderator
Please don't post the same question in multiple threads. I'll close this one for you.
I was born with webbed fish toes. This tiny ad is my only friend:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!