At 14:12 2018-10-10, "Paul H. Tarver" paul@tpcqpc.com wrote:
This is stupid advice.Don't hold back, Gene! Tell us how you really feel. LOL
In response to someone saying that an arbitrary number of indexes is great advice, I do not think my comment was at all out of line.
I think the point of the article was to help remind people to think about indexes before just using them without understanding the effects on performance. Having a rule of thumb like 5 indexes per table would make me stop and consider whether a 6th index was required. If so, then great. But at least I would have thought about the benefits and negatives before doing it. Frankly, reminding people to consider the consequences of their actions is NEVER stupid advice.
Sure. But putting an arbitrary in is not good advice. In a given case, it might be that having a fifth index is wrong, or maybe, it is fine until the tenth index.
You can consider the pluses and minuses without going arbitrary. After all, the idea of considering things is to avoid arbitraries.
[snip]
Sincerely,
Gene Wirchenko
On Oct 10, 2018, at 8:54 PM, Gene Wirchenko genew@telus.net wrote:
I think the point of the article was to help remind people to think about indexes before just using them without understanding the effects on performance. Having a rule of thumb like 5 indexes per table would make me stop and consider whether a 6th index was required. If so, then great. But at least I would have thought about the benefits and negatives before doing it. Frankly, reminding people to consider the consequences of their actions is NEVER stupid advice.
Sure. But putting an arbitrary in is not good advice. In a given case, it might be that having a fifth index is wrong, or maybe, it is fine until the tenth index.
“Rule of thumb” is not the same as “arbitrary”.
The former is based upon experience and observation. The latter is pulled out of thin air.
-- Ed Leafe
Just to throw some unconnected trivia into the debate I learnt a few days ago that 'Rule of thumb' refers to a miller checking the setting of the grindstones by rubbing the ground grain between thumb and forefinger. Thought you might like to know that 😊
John Weller 01380 723235 07976 393631 “Rule of thumb” is not the same as “arbitrary”.
The former is based upon experience and observation. The latter is pulled out of thin air.
On Oct 11, 2018, at 8:53 AM, John Weller john@johnweller.co.uk wrote:
Just to throw some unconnected trivia into the debate I learnt a few days ago that 'Rule of thumb' refers to a miller checking the setting of the grindstones by rubbing the ground grain between thumb and forefinger. Thought you might like to know that 😊
I had always heard a very different origin for that. From wikipedia:
"An 1824 court ruling in Mississippi stated that a man was entitled to enforce "domestic discipline" by striking his wife with a whip or stick no wider than the judge's thumb. In a later case in North Carolina (State v. Rhodes, 1868), the defendant was found to have struck his wife "with a switch about the size of this fingers"; the judge found the man not guilty due to the switch being smaller than a thumb.”
https://en.wikipedia.org/wiki/Rule_of_thumb
-- Ed Leafe
Now she won't tell him how many indexes are too many anymore.
Bad __Stephen
On Thu, Oct 11, 2018 at 9:40 AM Ed Leafe ed@leafe.com wrote:
On Oct 11, 2018, at 8:53 AM, John Weller john@johnweller.co.uk wrote:
Just to throw some unconnected trivia into the debate I learnt a few
days ago that 'Rule of thumb' refers to a miller checking the setting of the grindstones by rubbing the ground grain between thumb and forefinger. Thought you might like to know that 😊
I had always heard a very different origin for that. From wikipedia:
"An 1824 court ruling in Mississippi stated that a man was entitled to enforce "domestic discipline" by striking his wife with a whip or stick no wider than the judge's thumb. In a later case in North Carolina (State v. Rhodes, 1868), the defendant was found to have struck his wife "with a switch about the size of this fingers"; the judge found the man not guilty due to the switch being smaller than a thumb.”
https://en.wikipedia.org/wiki/Rule_of_thumb
-- Ed Leafe
[excessive quoting removed by server]