Page MenuHomePhabricator

Explore possibilities to provide full entity ids in labs
Closed, DeclinedPublic

Description

Possible ideas so far:

  • Add virtual column, to top-level entity-terms linking tables, that calculates full entity ids. Then add secondary indexes on these virtual columns only in labs.

    Problem with this is that those columns will appear in the tables => also in production. It might not matter though if they never get used by queries in production, but to keep such promise is hard once they are there.
  • Add secondary tables in labs that store mappings of full entity ids to top-level entity-terms linking tables

    Problem wit this is that this table need to be synced somehow

top-level entity-terms linking tables are tables such as wbt_item_terms and wbt_property_terms .. etc