Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on MongoDB shares jump more than 30% in $192M IPO. Parent comment
And you want to build indexes on half the table ?
Good luck with that.
Your math is at odds with your own requirements, null values don't need a row.
Sparcity is an issue for the wide table not the EAVT form.
And you want to build indexes on half the table ?
Good luck with that.