Very big database question. Need answers ?
-
Hello, I want to ask how Facebook database works like? For example if I consider only the FB posts that users put on this timeline, how that post table would work? Some statistics. 1. There would be more than 1 million posts every second. 2. Other users may be commenting on that posts too. Questions. 1. Is there only 1 post table or multiple posts table that contains user post based on their geographic location. This may help in reducing the load from a single post table. 2. Is Fb database has some different approach then the databases of normal (low traffic) website? 3. Every database whether Oracle or SQL server has a limit in terms of number of concurrent connection, no of inserts queries performing per second and so on. So how FB is doing this? Hope my questions make sense. Anyone who might be in FB database team might help me in my questions? thanks
-
Hello, I want to ask how Facebook database works like? For example if I consider only the FB posts that users put on this timeline, how that post table would work? Some statistics. 1. There would be more than 1 million posts every second. 2. Other users may be commenting on that posts too. Questions. 1. Is there only 1 post table or multiple posts table that contains user post based on their geographic location. This may help in reducing the load from a single post table. 2. Is Fb database has some different approach then the databases of normal (low traffic) website? 3. Every database whether Oracle or SQL server has a limit in terms of number of concurrent connection, no of inserts queries performing per second and so on. So how FB is doing this? Hope my questions make sense. Anyone who might be in FB database team might help me in my questions? thanks