https://bugzilla.wikimedia.org/show_bug.cgi?id=68918
--- Comment #6 from merl <[email protected]> --- Today i tried to run a script (missing articles) which has a lot of those deletion queries with many rows affected. It was not possible the run this script on labs before. After your update it is now possible to run these queries. So thx to Sean. The last hours i spend a lot in rewriting these queries because they still were really slow (although possible). The problem was that there is no index on page_props.pp_value. Now i solved this problem. It is really interesting that using the workaround i implemented today runs the query on labs about as fast as the old script version on toolserver, but running the new version on toolserver is three times slower than using the unindexed page_props.pp_value directly. Old version running on labs is about ten times slower. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
