[Bug 54465] Campaigns API call is very, very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=54465 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Priority|High|Normal --- Comment #10 from Andre Klapper aklap...@wikimedia.org --- (In reply to Yuvi Panda from comment #4) I can confirm once this rolls out to Commons on Monday. Yuvi? Also, still working on this (assignee field)? -- 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 54465] Campaigns API call is very, very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=54465 Nemo federicol...@tiscali.it changed: What|Removed |Added CC||br...@wikimedia.org --- Comment #7 from Nemo federicol...@tiscali.it --- *** Bug 55754 has been marked as a duplicate of this bug. *** -- 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 54465] Campaigns API call is very, very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=54465 --- Comment #9 from Kunal Mehta (Legoktm) legoktm.wikipe...@gmail.com --- parsercache* -- 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 54465] Campaigns API call is very, very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=54465 Kunal Mehta (Legoktm) legoktm.wikipe...@gmail.com changed: What|Removed |Added CC||legoktm.wikipe...@gmail.com --- Comment #8 from Kunal Mehta (Legoktm) legoktm.wikipe...@gmail.com --- Is Campaigns using pasercache? That seems like the easiest way to make it faster... -- 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 54465] Campaigns API call is very, very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=54465 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added CC||aklap...@wikimedia.org --- Comment #6 from Andre Klapper aklap...@wikimedia.org --- Yuvi, what's your status? -- 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 54465] Campaigns API call is very, very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=54465 --- Comment #5 from Mark Holmquist mtrac...@member.fsf.org --- Yuvi, what's your status? -- 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 54465] Campaigns API call is very, very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=54465 Fabrice Florin fflo...@wikimedia.org changed: What|Removed |Added Assignee|wikibugs-l@lists.wikimedia. |yuvipa...@gmail.com |org | --- Comment #3 from Fabrice Florin fflo...@wikimedia.org --- Yuvi, can you let us know if your latest patch has fixed this issue? -- You are receiving this mail because: You are the assignee for the bug. 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 54465] Campaigns API call is very, very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=54465 --- Comment #4 from Yuvi Panda yuvipa...@gmail.com --- Should be, yeah. I can confirm once this rolls out to Commons on Monday. Testwiki perf testing makes the calls complete in about 200ms, while it was close to a second before. A similar reduction on commons would be great. -- 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 54465] Campaigns API call is very, very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=54465 --- Comment #1 from Yuvi Panda yuvipa...@gmail.com --- Did some more investigation, and looks like DB hits aren't part of the problem (apergos ran EXPLAIN on the produced queries on production DB). Asking for all campaigns (~140 at this point) takes about 17s, 50 takes 7s, and 5 takes 0.7s. Seems to be sortof linear. Current suspicion is that all the wikitext parsing is what is causing the problem... -- You are receiving this mail because: You are the assignee for the bug. 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 54465] Campaigns API call is very, very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=54465 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Keywords||performance Priority|Unprioritized |High -- You are receiving this mail because: You are the assignee for the bug. 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 54465] Campaigns API call is very, very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=54465 --- Comment #2 from Brion Vibber br...@wikimedia.org --- Jotting down a quick note from IRC discussion: Making sure the parsed output is cached, and invalidating via standard refreshlinks jobqueue etc may help... I worry though that the multilanguage translation support will make this tricky; after a large invalidation the worst-case rendering time for 140+ campaigns would still be really terrible. A cheap hack to help might be to restrict the default paging limit on the API call, like some of the more expensive API calls do. This'd break up the worst-case rendering time into smaller individual requests which can return in decent time. Another solution might be to use a cheaper bulk call that doesn't translate anything but the campaign names, then fetch the details on a subsequent request if you need them. -- You are receiving this mail because: You are the assignee for the bug. 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