https://bugzilla.wikimedia.org/show_bug.cgi?id=57697
--- Comment #10 from Rainer Rillke @commons.wikimedia <ril...@wikipedia.de> --- Thank you. What I, however observe is that fa_sha1-queries are notably slower compared to img_sha1 queries and oi_sha1 queries: 18:38:38 SELECT * FROM commonswiki_p.image WHERE img_sha1="qtexhtbcwt0tnkuxb2wf3xs7d7j761u" LIMIT 0, 1000 1 row(s) returned 0.172 sec / 0.000 sec 18:36:31 SELECT * FROM commonswiki_p.oldimage WHERE oi_sha1="0mpoldytyxspxrdbf44r1kc7m8vtbq67" LIMIT 0, 1000 0 row(s) returned 0.156 sec / 0.000 sec 18:36:07 SELECT * FROM commonswiki_p.filearchive WHERE fa_sha1="0mpoldytyxspxrdbf44r1kc7m8vtbq67" LIMIT 0, 1000 1 row(s) returned 5.990 sec / 0.000 sec 5.990 sec vs. 0.172 sec is a huge difference. Is something broken with indexing? -- 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
