OraFAQ Forum: General » Performance issue

Home » Other » General » Performance issue (oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Performance issue [message #304454]

Wed, 05 March 2008 05:06

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?

Report message to a moderator

Re: Performance issue [message #304458 is a reply to message #304454]

Wed, 05 March 2008 05:14

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

Report message to a moderator

Re: Performance issue [message #304463 is a reply to message #304458]

Wed, 05 March 2008 05:24

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.

Report message to a moderator

Re: Performance issue [message #304482 is a reply to message #304463]

Wed, 05 March 2008 06:32

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Who read 2000 screens?

Regards
Michel

Report message to a moderator

Re: Performance issue [message #304625 is a reply to message #304482]

Wed, 05 March 2008 22:15

jazzcbe
Messages: 3
Registered: March 2008

Junior Member

Obviously users

Report message to a moderator

Re: Performance issue [message #304655 is a reply to message #304625]

Thu, 06 March 2008 00:57

Michel Cadot
Messages: 68647
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

Report message to a moderator

Re: Performance issue [message #304658 is a reply to message #304655]

Thu, 06 March 2008 01:05

rleishman
Messages: 3728
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

Unless of course Google is NOT sending me all the results..... Hmmm.

Attachment: google.GIF
(Size: 34.95KB, Downloaded 1657 times)

Report message to a moderator

Re: Performance issue [message #304667 is a reply to message #304658]

Thu, 06 March 2008 01:23

Michel Cadot
Messages: 68647
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

Report message to a moderator

Previous Topic:	oracle reports
Next Topic:	NLS_SORT and NLS_COMP parameters for Oracle Client

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 09:14:49 CDT 2024