Ladsgroup added a comment.
Two ideas for improving the current design:
- Normalize the table based on eu_aspect.
- While this would have been something I would do if I were to design the
table but it's clearly too much effort for too little gain on its own, maybe if
we merge this with the other, it'd be easier.
- Split the table to wbc_property_usage and wbc_item_usage and use numeric
ids there.
- I don't know what is the status of federation and if that can affect
feasibility of this idea (e.g. having property usage from two different repos
and how to track that).
We can also start looking at moving these table to x1 but that's not
something I can say "we should do it" on my own, DBAs need to look at the
feasibility, growth, capacity, etc. before saying this is doable. You will lose
the ability to join and I think this just moves the problem from one place to
another.
TASK DETAIL
https://phabricator.wikimedia.org/T188730
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Ladsgroup
Cc: Marostegui, RP88, Michael, Lucas_Werkmeister_WMDE, hoo, daniel,
zhuyifei1999, Eloquence, Lydia_Pintscher, Sannita, Ainali, Liuxinyu970226,
MZMcBride, Ricordisamoa, iecetcwcpggwqpgciazwvzpfjpwomjxn, jayvdb,
Daniel_Mietchen, Tobi_WMDE_SW, Legoktm, Abraham, greg, Wikidata-bugs, liangent,
jeremyb, aude, Bianjiang, Aklapper, DixonD, PokestarFan, Ladsgroup,
karapayneWMDE, joanna_borun, Bongo-Cat, Invadibot, Devnull, LSobanski,
maantietaja, Y.ssk, lmata, Muchiri124, CBogen, Akuckartz, Iflorez, RhinosF1,
Legado_Shulgin, ReaperDawn, Nandana, lucamauri, Davinaclare77, Techguru.pc,
Lahi, Gq86, GoranSMilovanovic, Hfbn0, QZanden, LawExplorer, Minhnv-2809, Zppix,
Poyekhali, _jensen, rosalieper, Taiwania_Justo, Scott_WUaS, Ixocactus,
Wong128hk, El_Grafo, Dinoguy1000, faidon, Addshore, Steinsplitter, Mbch331,
Jay8g, Krenair, fgiunchedi
_______________________________________________
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org
