Home » RDBMS Server » Performance Tuning » Database is slow.
icon3.gif  Database is slow. [message #264235] Sun, 02 September 2007 04:43 Go to next message
sanjay_kant
Messages: 25
Registered: February 2007
Junior Member

One report which is based on 10 table user ganerates every morning n evening time, which takes 15 mints always. but one day use complaint me in evening time that same report taking more than 1 hrs. same report has taken 15 mints in morning. where is the problem n how to solve it?
Re: Database is slow. [message #264242 is a reply to message #264235] Sun, 02 September 2007 05:49 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

It is because the load of database. May be other processes were running in evening time and while running other processes you were generating reports.
Re: Database is slow. [message #264265 is a reply to message #264235] Sun, 02 September 2007 09:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you read and apply what is in the sticky on top of the forum?

Regards
Michel
Re: Database is slow. [message #264266 is a reply to message #264265] Sun, 02 September 2007 10:19 Go to previous messageGo to next message
sanjay_kant
Messages: 25
Registered: February 2007
Junior Member

there are not so many processes.. i think its not reason
Re: Database is slow. [message #264294 is a reply to message #264235] Sun, 02 September 2007 22:16 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

It is your database, One time it is slow and in another time fast. You have the better idea than everyone else, who have not used your system.
Re: Database is slow. [message #264299 is a reply to message #264266] Sun, 02 September 2007 23:08 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Maybe someone sets the hidden parameter
db_fast =False
in the morning Very Happy
Seriously though, this is a nonsense question. If we were to ask you the following question:
"Usually,something on my computer takes 5 minutes, now it takes 4 times as long. Why is this?" What answer would you supply? The point I am making is that you have supplied no information whatsoever that could be used to help you. Arju supplied what is basically, the best possible guess based on the (no) information that you supplied and you basically say "Nope, this isn't why" without offering any evidence. Well, I say to you, YES, this IS the reason why. Prove us wrong by posting valid tests on your system. But before you do ANY of that, have the courtesy to
read the sticky at the top of the forum
Previous Topic: Duplicating ** million record table
Next Topic: Hash join vs NL join
Goto Forum:
  


Current Time: Mon Dec 05 10:50:09 CST 2016

Total time taken to generate the page: 0.14964 seconds