| Marostegui added a comment. |
In T159718#3077513, @jcrespo wrote:
- Populate new column at the same time than the current one (ideally with code, but if you do not want to touch code, it can even be made with a trigger) + populate old values with maintenance
If possible, I would avoid using triggers on such big (and potentially concurrent) table and I would try to stick to the code to populate the column if this is not a lot of extra work.
The reason for it is just based on past experiences with triggers on big big tables (and this is quite a big table) and the load they might (or might not, depending on the usage) put on the server.
TASK DETAIL
EMAIL PREFERENCES
To: Marostegui
Cc: jcrespo, Marostegui, Lydia_Pintscher, Aklapper, daniel, WMDE-leszek, Minhnv-2809, D3r1ck01, Izno, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
Cc: jcrespo, Marostegui, Lydia_Pintscher, Aklapper, daniel, WMDE-leszek, Minhnv-2809, D3r1ck01, Izno, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
