3 ms·
> 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 give
by flukus 9y ago
> 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 9y agoEAVT 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.