View previous topic :: View next topic
|
Author |
Message |
Rahul_kumar Warnings : 2 New User
Joined: 24 Jun 2006 Posts: 50
|
|
|
|
Hi,
In an existing code which I am modifying I can see an unnecessary column being fetched from the table and is being updated without any processing which I feel is an overhead since there are n no. of records which will be fetched and later updated.So ,I need to remove that unnecessary column which is being fetched but want to know how much performance it can improve in case a justification is required from my end for this change.Can anyone please help.
Thanks,
rahul |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
why a performance justification? from a data security perspective,
the actvities of the code is from a business perspective - incorrect.
but if you want an algorithm, this is the one that I use:
3**47(column-length-factor) - 8**21(total-row-count)
/
total-rows-retrieved * irritation-factor |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
the wisest thing would be to ask inside Your organization about ...
CODE CLEANUP policy
it has nothing to do with the performance yet.
maybe the preceding revision of the program was really updating those columns
and in order not to break the overall logic the IO was left there
better ask! |
|
Back to top |
|
|
Rahul_kumar Warnings : 2 New User
Joined: 24 Jun 2006 Posts: 50
|
|
|
|
hmm..better not to do anything with the existing logic
Thanks for the suggestions!! |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Just remove it. If another program uses that column it will go down and
then you know the column was not there for fun.
Ok, you will have to do some explanation to some people. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Quote: |
3**47(column-length-factor) - 8**21(total-row-count)
/
total-rows-retrieved * irritation-factor |
Is the irritation-factor a universal-constant, like, Universal Gravitational Constant (G) - or it's varaible? And I'd wonder if it is part of denominator... |
|
Back to top |
|
|
|