Hacker News new | ask | show | jobs
by threeseed 3168 days ago
EAVT table with 100 million entities and 10000 attributes = one trillion row table.

And you want to build indexes on half the table ?

Good luck with that.

1 comments

> Often with most of the values set to null.

Your math is at odds with your own requirements, null values don't need a row.

You clearly don't understand what you're talking about.

Sparcity is an issue for the wide table not the EAVT form.