• Post Reply Bookmark Topic Watch Topic
  • New Topic

Delay during population of textfields

 
Sugantha Jeevankumar
Ranch Hand
Posts: 93
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a swing based application that uses Oracle dB release 10.2.0.2.0.

In one of the screens, there is a key field where I need to enter a key value. When tab is pressed, the rest of the fields in the screen are populated. The issue is with the time taken for populating the field values. While I populate the values for the first time it takes roughly 8 seconds, but during subsequent times it takes only 2 seconds. What could be the reason for such a behaviour.

Any pointers would be much helpful. Thanks in advance.
 
Maneesh Godbole
Bartender
Posts: 11445
18
Android Eclipse IDE Google Web Toolkit Java Mac Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Instead of populating from the DB, have you tried populating from a flat file/hard coded values. For all you know the DB might be caching the values.
 
mark goking
Ranch Hand
Posts: 155
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
there's no solution to this, since you're querying to the db, there'll be delays.

you can either add something fancy like a progressbar so that the user won't have to wonder if the program hang up or is still retrieving from the db
 
Maneesh Godbole
Bartender
Posts: 11445
18
Android Eclipse IDE Google Web Toolkit Java Mac Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Mark,
I think you missed the point.
The question was regarding a difference in time delay on subsequent calls to the DB. To confirm if it was a DB side issue, I had asked to OP to switch from DB to flat files.
 
Pari Nanoti
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Sugantha Jeevankumar
While I populate the values for the first time it takes roughly 8 seconds, but during subsequent times it takes only 2 seconds


Are you making the connection to the DB, or running any extra code when you hit the tab button for the first time?
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!