3 ms·
At Digg we had probably a hundred or so tables, each table had varying indexes (a char here, an integer there, a date+time here) This may be part of the proble
by StrawberryFrog 17y ago
At Digg we had probably a hundred or so tables, each table had varying indexes (a char here, an integer there, a date+time here)
This may be part of the problem, actually. 100 tables to serve posts with attached comments? Um.
- blinks 17y agoThere's a bit more going on there. See http://www.codinghorror.com/blog/2009/07/code-its-trivial.html http://www.codinghorror.com/blog/2009/07/code-its-trivial.ht... for a related principle.
- houseabsolute 17y agoTrue, but I can't imagine more than a couple of those tables are accessed at the high frequency rate that requires performance optimization.
- wvenable 17y agoActually, my thinking was 100 tables... so what! That's not a large number. Any software of average complexity will have 100 tables, easy.