Home » Other » General » Performance issue (oracle 9i)
icon9.gif  Performance issue [message #304454] Wed, 05 March 2008 05:06 Go to next message
jazzcbe
Messages: 3
Registered: March 2008
Junior Member
I have an application that fetches data from the table and displays it in a grid. Since the data im fetching is too large(about 2 lakh records) it is taking approx. 2 minutes to load the grid. Is there any way to reduce this time delay?
Re: Performance issue [message #304458 is a reply to message #304454] Wed, 05 March 2008 05:14 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Don't tell me you are getting all the records from the backend to front end (200,000) in a single fetch. If that's the case I am completely spell bound.

Regards

Raj
Re: Performance issue [message #304463 is a reply to message #304458] Wed, 05 March 2008 05:24 Go to previous messageGo to next message
jazzcbe
Messages: 3
Registered: March 2008
Junior Member
Yes, im getting them in a single fetch. But im displaying only 100 records at a time.
Re: Performance issue [message #304482 is a reply to message #304463] Wed, 05 March 2008 06:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Who read 2000 screens?

Regards
Michel
Re: Performance issue [message #304625 is a reply to message #304482] Wed, 05 March 2008 22:15 Go to previous messageGo to next message
jazzcbe
Messages: 3
Registered: March 2008
Junior Member
Obviously users
Re: Performance issue [message #304655 is a reply to message #304625] Thu, 06 March 2008 00:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know any user reading 2000 screens.
One screen, maybe 2, 3 for the most relentless users.
You should investigate how to return more appropriate data, just the really needed ones.

Regards
Michel
Re: Performance issue [message #304658 is a reply to message #304655] Thu, 06 March 2008 01:05 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Hey, 2.17 Billion rows downloaded to my web cache in 0.07 sec. Must be magic. Shocked

./fa/3981/0/

Unless of course Google is NOT sending me all the results..... Hmmm.
  • Attachment: google.GIF
    (Size: 34.95KB, Downloaded 263 times)
Re: Performance issue [message #304667 is a reply to message #304658] Thu, 06 March 2008 01:23 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It just gives an estimation (and not a real number) and try to directly go to page 100 and you're out.

There were discussions on this on AskTom getting rows N through M of a result set (search for google all along this one).

Regards
Michel
Previous Topic: oracle reports
Next Topic: NLS_SORT and NLS_COMP parameters for Oracle Client
Goto Forum:
  


Current Time: Sun Dec 04 23:07:10 CST 2016

Total time taken to generate the page: 0.12917 seconds