Re:Dev Watercooler: World of Warcraft Classic
by ckaygusu on Sunday June 17, 2018 @09:34AM
(#17332307)
I'm yet to have the privilege to work on a database which I would call truly "massive", so I'm oblivious to how things work in such environment in reality. I've seen the question and the answer you've given repeats many times, but aren't there exists a plethora of tools like table partitioning, materialized views etc. to allow one to have the database in a normalized form and run it fast? Don't they work in practice?
[ Parent
| on HN ]
Re:Dev Watercooler: World of Warcraft Classic
by jeremyjh on Sunday June 17, 2018 @10:40AM
(#17332535)
Table partitioning does nothing to solve the performance problems of joins of very large datasets. Materialized views can help but they are not a panacea. You have to trigger the updates yourself, and because they are updated asynchronously, you will not have a consistent view of your data. E.g. you could write a row to the database and not see it updated in your view for minutes.