Home » RDBMS Server » Performance Tuning » disadvantages of optimization
disadvantages of optimization [message #286154] Thu, 06 December 2007 10:52 Go to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
Hello,

please tell me disadvantges of optimization

regards
Anamika
Re: disadvantages of optimization [message #286155 is a reply to message #286154] Thu, 06 December 2007 10:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Hypothetically, I suppose, your database/application/server/whatever it is , ***may*** perform better?.
The question makes little sense. Could you please be specific?

[Updated on: Thu, 06 December 2007 10:57]

Report message to a moderator

Re: disadvantages of optimization [message #286157 is a reply to message #286155] Thu, 06 December 2007 10:59 Go to previous messageGo to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
it is database and i just want to know to the disdavntages of optimization...

i do not know the disadvtanges of optimization...
Re: disadvantages of optimization [message #286158 is a reply to message #286157] Thu, 06 December 2007 11:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
There is always optimization, whatever you do, so the question is irrelevant.

Regards
Michel
Re: disadvantages of optimization [message #286161 is a reply to message #286157] Thu, 06 December 2007 11:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Again,

Quote:


op·ti·mi·za·tion /ˌɒptəməˈzeɪʃən/ Pronunciation Key - Show Spelled Pronunciation[op-tuh-muh-zey-shuhn] Pronunciation Key - Show IPA Pronunciation
1. the fact of optimizing; making the best of anything.


What disadvantages you see in making something work better?
May be , need to understand the subject matter more?
Re: disadvantages of optimization [message #286162 is a reply to message #286154] Thu, 06 December 2007 11:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>please tell me disadvantges of optimization
It takes time, energy, & knowledge to produce optimal performance.
For some folks, they only have time to go in circles.
Re: disadvantages of optimization [message #286514 is a reply to message #286154] Fri, 07 December 2007 13:28 Go to previous messageGo to next message
gintsp
Messages: 118
Registered: February 2007
Senior Member
Spent resources and $$$
You should know what to optimize and how far to optimize i.e. when to stop. Otherwise one can do optimizing forever because always there are things that can be better. One has to understand the border when the price of optimization is no more worth the better performance you got.

Gints Plivna

[Updated on: Fri, 07 December 2007 13:40] by Moderator

Report message to a moderator

Re: disadvantages of optimization [message #286515 is a reply to message #286154] Fri, 07 December 2007 13:36 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>please tell me disadvantges of optimization
Compulsive Tuning Disorder - when things are never good enough
Previous Topic: the query is too slow
Next Topic: A question about SQL * net message in a batch program
Goto Forum:
  


Current Time: Tue Nov 26 21:36:21 CST 2024