metamemetics
Joined 17 years ago
Joined 17 years ago
Regardless, I think my initial question regarding when to denormalize data applies to any database including scaled MySQL, but perhaps was a better question for stackoverflow.
Looking for a way to hands-free scale very cheaply without vendor lockin. Would be nice if I can simply add another machine to the database to the cluster. And not have to generate the ids in the application layer, use hashing algo to select correct machine, and have everything stop working when a single database goes down. Seems like it should be a solved problem by now. Investigating new tech won't set me back much time, and my MySQL queries aren't going to disappear if I don't like it. Furthermore looking at large sites such as Flickr that massively scaled MySQL it seems like they stopped using its relational features anyway.
My mind is still thinking in 3NF though. I understand dernormalization and avoiding joins will be useful from a performance standpoint. However I am unsure when to either go ahead and include a foreign key, retrieve it and perform a second query from the application layer, and when to go ahead and duplicate\embed all the field data. I'm leaning towards just making 2 simple sequential key lookup queries, the 2nd on the retrieved foreign key, rather than duplicating fields everywhere and keeping track of massively cascading changes. Instead of performing 1 MySQL Join. Although I usually think in terms of minimizing roundtrips to the database server.
Wondering if anyone has a heuristic for this or suggested reading?
How would you differentiate between the terms wealth, freedom, and happiness (or do you consider them interchangeable)?
I think from those 3, 'wealth' has the heaviest connotation of objective comparability and applicability to organizations in addition to individuals. (ex. a wealthy company or a wealthy country)
Skills you know, your business network, your emotional support network, assets you can exchange.
People with great wealth can affect the world in profoundly positive or negative ways. In other words, wealth is closely tied to the notion of power.
A member of congress who has relatively low networth could have as much financial influence as Bill Gates. While this power is not as liquid or easy to exchange as cash, it is still exchangeable and a store of value.
[ To directly answer the OP: No we should not exclude speculation, everything is speculation to some small degree. Even holding everything in cash is a speculation on that nation's currency. We'd have to use other measures to estimate expected security\longevity, like liquidity of assets. ]
Give him a break, getting healthcare reform passed already involved flame-baiting half of congress to the extreme. There's a thing called filibustering that massively slows down all legislature once anyone bill becomes flame-baitable enough. There is no way any president could have halted the greatest financial collapse since the great depression, passed education reform, passed healthcare reform, AND also gotten to a new energy\immigration policy in 18 months, while filibustering exists, without assuming dictatorial power.
"Gains" obviously did not refer to strictly cash. Gains refers to anything you value. Cash is just a tool. I would go further than you and say the vast majority of entrepreneurs seek autonomy. Use occam's razor when interpreting the statements of others.
Utility is a basic textbook economics term and the context of Arrington's article. Also, Arrington was an economics major. I think sticking to one terminology is highly preferable over acontextual obscurism.
I believe one should make the strongest defensible statement possible.