Home » RDBMS Server » Performance Tuning » Query Executing Every Second (Oracle 9i,9.2.0.6.0,windows XP)
Query Executing Every Second [message #318026] Mon, 05 May 2008 06:40 Go to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Dear all,

If a query is executing every second then what should be the points to consider regarding it's tuning.

Regards,
Rajat Ratewal
Re: Query Executing Every Second [message #318037 is a reply to message #318026] Mon, 05 May 2008 07:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not executing it every second. Wink

Regards
Michel
Re: Query Executing Every Second [message #318040 is a reply to message #318037] Mon, 05 May 2008 07:04 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Thanks Michel For the suggestion.

But i can't stop it executing every second.

Would you please provide me the answer for this.

Regards,
Rajat Ratewal
Re: Query Executing Every Second [message #318053 is a reply to message #318040] Mon, 05 May 2008 08:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
But i can't stop it executing every second.

Why?

Regards
Michel
Re: Query Executing Every Second [message #318146 is a reply to message #318053] Mon, 05 May 2008 22:22 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Dear Michel have you seen sensex bar that displays current status of the prices for different companies.In our application same kind of thing is used.Every second this query is executed to get the current details from the database and display it in a moving bar.So every time a page is refreshed i have to execute it again and again.Like i have to get count from a particular table so every time it will going to scan the index or table again and again which takes time.

I hope this will clear your doubts.

Regards,
Rajat Ratewal
Re: Query Executing Every Second [message #318149 is a reply to message #318146] Mon, 05 May 2008 22:49 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 your examples, what I mean is that a query needs to be executed every second only if someone look at it every second.
In addition, what is your business need that requires a near real time precision? Does a value that is aged of 5 seconds, 10 seconds, 1 minute or even more not sufficient?

Regards
Michel
Re: Query Executing Every Second [message #318154 is a reply to message #318149] Mon, 05 May 2008 23:03 Go to previous message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Ok Michel i got your point may be you are right that i don't have to execute it every second.If data is displayed in 5 minutes interval than it will be OK.

Thanks for your suggestions.

Previous Topic: Data Statistics
Next Topic: Performance Tuning for a package
Goto Forum:
  


Current Time: Sun Dec 04 23:06:05 CST 2016

Total time taken to generate the page: 0.05401 seconds