[flukus]

> EAVT is great as an intermediate format but it is absolutely useless to query for since most of the time you are trying to find a set of attributes for a given entity i.e. full table scan.

This is what indexes are for. An index on the entity id should avoid any full table scans.

[threeseed]

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.

[flukus]

> 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.

[threeseed]

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

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