4 ms·
These design techniques could very well make a nice impact on performance. Then again, they might not. Why? They are proposals to solve a problem that has no
by edw519 19y ago
These design techniques could very well make a nice impact on performance. Then again, they might not.
Why? They are proposals to solve a problem that has not yet been defined.
Fact is, you don't know what the problem is.
So proposing a database solution to what could just as easily be a memory management or throughput problem is premature.
- hank777 19y agoThis is true. Though I can say that if one were building twitter and you didnt either have a design like the one I suggested, or a design with some kind of distributed caching then you are going to have exactly the kinds of scaling problems they have had. In other words if you use tradition techniques for something like twitter you are screwed. However you are absolutely right that (as I said in my piece) they may already, for example have thought of all of this and either implemented or dismissed it because they have a better design, and I have no way of knowing.
- menloparkbum 19y agoThis isn't true. You don't need a distributed sharded setup in order to scale. (You probably do if you are limiting yourself to MySQL) I built financial applications way back in the day that had a lot more reads and writes than twitter, and we just used ONE gigantic, super expensive database server.