[Bug 56711] Update the wb_terms table so it does not have a numeric entity id
https://bugzilla.wikimedia.org/show_bug.cgi?id=56711 Jeroen De Dauw jeroen_ded...@yahoo.com changed: What|Removed |Added Blocks||73496 -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56711] Update the wb_terms table so it does not have a numeric entity id
https://bugzilla.wikimedia.org/show_bug.cgi?id=56711 Lydia Pintscher lydia.pintsc...@wikimedia.de changed: What|Removed |Added Blocks||64288 -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56711] Update the wb_terms table so it does not have a numeric entity id
https://bugzilla.wikimedia.org/show_bug.cgi?id=56711 Lydia Pintscher lydia.pintsc...@wikimedia.de changed: What|Removed |Added Whiteboard|termsearch u=dev c=backend |termsearch u=dev c=backend |p=0 |p=20 -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56711] Update the wb_terms table so it does not have a numeric entity id
https://bugzilla.wikimedia.org/show_bug.cgi?id=56711 tobias.gritschac...@wikimedia.de changed: What|Removed |Added Depends on||68378 -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56711] Update the wb_terms table so it does not have a numeric entity id
https://bugzilla.wikimedia.org/show_bug.cgi?id=56711 Thiemo Mättig thiemo.maet...@wikimedia.de changed: What|Removed |Added CC||thiemo.maet...@wikimedia.de --- Comment #4 from Thiemo Mättig thiemo.maet...@wikimedia.de --- Springle wrote at https://gerrit.wikimedia.org/r/#/c/101197/ This one still seems dangerous to me :-) I understand the reason for the change, however please do also consider: 1. Have we done any real profiling of the new query forms against the production dataset? I'd really like to see how much of an impact this has on data and index disk usage, and more importantly on runtime memory usage. Happy to do this if a Dev can generate a few thousand samples of each query type... 2. Would it be wise to keep a numeric entity id field as an interim step on the wikidata production dataset, so we can fail back if needs be? Ie, treat this as a denormalization step (which is /all it is/ for now) until #1 is assured? That might even make the migration less painful. 3. VARBINARY(255) smells like an arbitrary size choice :-) Variable field widths really start to matter for large datasets as the server must convert it to fixed-width BINARY while working. If the choice /was/ arbitrary, can we arbitrarily choose to make this smaller from the get go? -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56711] Update the wb_terms table so it does not have a numeric entity id
https://bugzilla.wikimedia.org/show_bug.cgi?id=56711 Lydia Pintscher lydia.pintsc...@wikimedia.de changed: What|Removed |Added Whiteboard|backlog, termsearch u=dev |termsearch u=dev c=backend |c=backend p=0 |p=0 -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56711] Update the wb_terms table so it does not have a numeric entity id
https://bugzilla.wikimedia.org/show_bug.cgi?id=56711 Lydia Pintscher lydia.pintsc...@wikimedia.de changed: What|Removed |Added Priority|Unprioritized |High -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56711] Update the wb_terms table so it does not have a numeric entity id
https://bugzilla.wikimedia.org/show_bug.cgi?id=56711 Lydia Pintscher lydia.pintsc...@wikimedia.de changed: What|Removed |Added Whiteboard|backlog, termsearch u=dev |backlog, termsearch u=dev |c=WikidataRepo p=3 |c=backend p=0 -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56711] Update the wb_terms table so it does not have a numeric entity id
https://bugzilla.wikimedia.org/show_bug.cgi?id=56711 christopher.john...@wikimedia.de changed: What|Removed |Added Whiteboard|backlog, termsearch |backlog, termsearch u=dev ||c=WikidataRepo p=3 -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56711] Update the wb_terms table so it does not have a numeric entity id
https://bugzilla.wikimedia.org/show_bug.cgi?id=56711 Jeroen De Dauw jeroen_ded...@yahoo.com changed: What|Removed |Added CC||jeroen_ded...@yahoo.com --- Comment #3 from Jeroen De Dauw jeroen_ded...@yahoo.com --- I fixed compat with sqlite and several other issues. The tests now pass: https://gerrit.wikimedia.org/r/#/c/114490/ The commits are doing some stuff I don't like, though that can be fixed after we got rid of the main issue, the bad assumption in the table, which this commit fixes. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56711] Update the wb_terms table so it does not have a numeric entity id
https://bugzilla.wikimedia.org/show_bug.cgi?id=56711 tobias.gritschac...@wikimedia.de changed: What|Removed |Added Status|ASSIGNED|PATCH_TO_REVIEW --- Comment #2 from tobias.gritschac...@wikimedia.de --- https://gerrit.wikimedia.org/r/#/c/101197/ -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56711] Update the wb_terms table so it does not have a numeric entity id
https://bugzilla.wikimedia.org/show_bug.cgi?id=56711 --- Comment #1 from Daniel Kinzler daniel.kinz...@wikimedia.de --- Rationale: we are dropping the assumption that ids will always be prefix+number. For the current code and use case, wikidata.org, this works fine, but we need to migrate away from this in order to support things like meta-data storage on commons. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56711] Update the wb_terms table so it does not have a numeric entity id
https://bugzilla.wikimedia.org/show_bug.cgi?id=56711 Daniel Kinzler daniel.kinz...@wikimedia.de changed: What|Removed |Added Status|NEW |ASSIGNED -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56711] Update the wb_terms table so it does not have a numeric entity id
https://bugzilla.wikimedia.org/show_bug.cgi?id=56711 Daniel Kinzler daniel.kinz...@wikimedia.de changed: What|Removed |Added CC||daniel.kinz...@wikimedia.de Whiteboard|backlog |backlog, termsearch -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56711] Update the wb_terms table so it does not have a numeric entity id
https://bugzilla.wikimedia.org/show_bug.cgi?id=56711 Lydia Pintscher lydia.pintsc...@wikimedia.de changed: What|Removed |Added Status|ASSIGNED|NEW CC||lydia.pintscher@wikimedia.d ||e Whiteboard||backlog -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56711] Update the wb_terms table so it does not have a numeric entity id
https://bugzilla.wikimedia.org/show_bug.cgi?id=56711 tobias.gritschac...@wikimedia.de changed: What|Removed |Added Status|NEW |ASSIGNED -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l