| Marostegui added a comment. |
@hoo after db1109 has been recloned (and now has compressed tables):
[email protected][wikidatawiki]> SELECT COUNT(*) FROM wb_changes_dispatch; +----------+ | COUNT(*) | +----------+ | 577 | +----------+ 1 row in set (0.00 sec)
[email protected][wikidatawiki]> SELECT chd_site FROM wb_changes_dispatch WHERE (( chd_touched < '20181010214641' OR ( 1086 - chd_seen ) > 1000) ) AND (chd_seen < 1086) AND (chd_disabled = 0) ORDER BY chd_seen ASC LIMIT 15; Empty set (0.00 sec)
Which is better than what you were getting at T205865#4656722
Can you re-run your tests?
TASK DETAIL
EMAIL PREFERENCES
To: Marostegui
Cc: Nikerabbit, Stashbot, gerritbot, aaron, hoo, Joe, User-Marostegui, Banyek, jcrespo, Marostegui, Addshore, Aklapper, CucyNoiD, Nandana, NebulousIris, thifranc, jijiki, AndyTan, Gaboe420, Phukettaxigroup, Versusxo, Majesticalreaper22, Giuliamocci, Davinaclare77, Adrian1985, Qtn1293, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Jayprakash12345, Th3d3v1ls, Hfbn0, Ramalepe, Liugev6, QZanden, LawExplorer, Vali.matei, Lewizho99, Minhnv-2809, Zppix, Volans, Maathavan, D3r1ck01, Volker_E, Wong128hk, Luke081515, Wikidata-bugs, aude, GWicke, Dinoguy1000, faidon, Mbch331, Jay8g, Krenair, akosiaris, fgiunchedi
Cc: Nikerabbit, Stashbot, gerritbot, aaron, hoo, Joe, User-Marostegui, Banyek, jcrespo, Marostegui, Addshore, Aklapper, CucyNoiD, Nandana, NebulousIris, thifranc, jijiki, AndyTan, Gaboe420, Phukettaxigroup, Versusxo, Majesticalreaper22, Giuliamocci, Davinaclare77, Adrian1985, Qtn1293, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Jayprakash12345, Th3d3v1ls, Hfbn0, Ramalepe, Liugev6, QZanden, LawExplorer, Vali.matei, Lewizho99, Minhnv-2809, Zppix, Volans, Maathavan, D3r1ck01, Volker_E, Wong128hk, Luke081515, Wikidata-bugs, aude, GWicke, Dinoguy1000, faidon, Mbch331, Jay8g, Krenair, akosiaris, fgiunchedi
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
