OraFAQ Forum: Performance Tuning » Query Executing Every Second

Home » RDBMS Server » Performance Tuning » Query Executing Every Second (Oracle 9i,9.2.0.6.0,windows XP)

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

Query Executing Every Second [message #318026]

Mon, 05 May 2008 06:40

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

Report message to a moderator

Re: Query Executing Every Second [message #318037 is a reply to message #318026]

Mon, 05 May 2008 07:00

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Not executing it every second. Wink

Regards
Michel

Report message to a moderator

Re: Query Executing Every Second [message #318040 is a reply to message #318037]

Mon, 05 May 2008 07:04

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

Report message to a moderator

Re: Query Executing Every Second [message #318053 is a reply to message #318040]

Mon, 05 May 2008 08:22

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

But i can't stop it executing every second.

Why?

Regards
Michel

Report message to a moderator

Re: Query Executing Every Second [message #318146 is a reply to message #318053]

Mon, 05 May 2008 22:22

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

Report message to a moderator

Re: Query Executing Every Second [message #318149 is a reply to message #318146]

Mon, 05 May 2008 22:49

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Query Executing Every Second [message #318154 is a reply to message #318149]

Mon, 05 May 2008 23:03

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 01:41:38 CST 2024