2 ms·
And that's fine, but you obviously did some investigation: what irks me is people trotting out this line about insert performance with no investigation. Of cou
by bartread 7y ago
And that's fine, but you obviously did some investigation: what irks me is people trotting out this line about insert performance with no investigation.
Of course, if you over-index a table, there can be some impact but in the general case that I've seen over the years that's seldom the problem.
- ShinTakuya 7y agoOh okay, I can agree with you there. But I think as a general rule, if something is done less than once a day and it's already a heavily indexed table you can probably skip the index unless it's a massive or potentially massive table. In that case it may be worth exploring alternatives.