Joel Liu's personal annotations on this page
Joel bookmarked
on 2008-01-21
-
"started as a big vertically scaled classic replication tree (well, started as a
single box) and soon hit against performance walls in terms of writes (repl
gives you more reads, same writes as slowest machine in your tree). when we
started, we barely knew anything about how mysql works with indexes (the
documentation is fairly non-beginner), so months of index wrangling to get
better performance ensued.
This link has been bookmarked by 30 people . It was first bookmarked on 03 Aug 2006, by Sean E Keener.
-
Bruno MartinsContinuing my series of queries about how "Web 2.0" companies used databases, I asked Cal Henderson of Flickr to tell me "how the folksonomy model intersects with the traditional database. How do you manage a tag cloud?"
-
-
"started as a big vertically scaled classic replication tree (well, started as a
single box) and soon hit against performance walls in terms of writes (repl
gives you more reads, same writes as slowest machine in your tree). when we
started, we barely knew anything about how mysql works with indexes (the
documentation is fairly non-beginner), so months of index wrangling to get
better performance ensued.
-
-
Jason WehmhoenerHe replied: "lots of the 'web 2.0' feature set doesn't fit well with traditional normalised db schema design. denormalization (or heavy caching) is the only way to generate a tag cloud in milliseconds for hundereds of millions of tags. you can cache stuff
-
-
Database War Stories
-
Would you like to comment?
Join Diigo for a free account, or sign in if you are already a member.