[04:58:00] dsaez: test is working. ;) [07:50:49] 10Quarry: Quarry runs thousands times slower in last months - https://phabricator.wikimedia.org/T160188#3668422 (10jcrespo) Quarry switched to the new servers on Tue, Sep 26 (less than 2 weeks ago), so if that has been happening "in last months", it is not that. The only change I can see, which applies to both s... [07:58:19] 10Quarry: Quarry runs thousands times slower in last months - https://phabricator.wikimedia.org/T160188#3668444 (10jcrespo) Actually, running your first query, takes: ``` 8 rows in set (7.85 sec) ``` on the new analytics server, while I it took >200 seconds on labsdb1001: ``` 8 rows in set (3 min 52.05 sec)... [08:20:04] 10Quarry: Quarry runs thousands times slower in last months - https://phabricator.wikimedia.org/T160188#3668482 (10jcrespo) I had to kill the second query after 1000 seconds: ``` | Query | 983 | Queried about 131240000 rows | select distinct(con... [08:58:58] https://meta.wikimedia.org/wiki/Research:Freedom_of_panorama_survey_among_architects_of_Italy [09:17:33] 10Quarry: Quarry runs thousands times slower in last months - https://phabricator.wikimedia.org/T160188#3668723 (10IKhitron) Hi, @jcrespo. All that you told me, I don't think you should it to me. I just use quarry, don't choose between analytics and something, I don't know what they are. You don't need to compar... [09:21:19] 10Quarry: Quarry runs thousands times slower in last months - https://phabricator.wikimedia.org/T160188#3668749 (10jcrespo) @IKhitron It is ok, quarry maintainers will know what to do with the information I have written :-) [09:28:42] 10Quarry: Quarry runs thousands times slower in last months - https://phabricator.wikimedia.org/T160188#3668761 (10IKhitron) Sure, @jcrespo, but you talked to me ("your query"), so I answered. [14:24:49] Hey research folks! https://phabricator.wikimedia.org/T177515! [14:24:52] Time is running out! [14:39:28] halfak: 404 Not Found [14:39:37] oh, is the ! [14:39:48] :D [14:39:52] My client doesn't include the ! in the URL [19:25:22] halfak: is arnad one of your volunteers? [19:28:48] 10Quarry: Quarry runs thousands times slower in last months - https://phabricator.wikimedia.org/T160188#3670403 (10zhuyifei1999) 05Open>03Resolved Dunno if anything needs to be done here. [19:30:56] 10Quarry: Quarry runs thousands times slower in last months - https://phabricator.wikimedia.org/T160188#3670406 (10IKhitron) >>! In T160188#3670403, @zhuyifei1999 wrote: > Dunno if anything needs to be done here. Do you mean it will stay work quickly like this for good? [19:34:07] 10Quarry: Quarry runs thousands times slower in last months - https://phabricator.wikimedia.org/T160188#3670411 (10zhuyifei1999) >>! In T160188#3670406, @IKhitron wrote: > Do you mean it will stay work quickly like this for good? Quarry will use the new faster analytic servers, yes. But how the query executes i... [19:35:44] 10Quarry: Quarry runs thousands times slower in last months - https://phabricator.wikimedia.org/T160188#3670428 (10IKhitron) >>! In T160188#3670411, @zhuyifei1999 wrote: >>>! In T160188#3670406, @IKhitron wrote: >> Do you mean it will stay work quickly like this for good? > > Quarry will use the new faster anal... [19:37:03] 10Quarry: Quarry runs thousands times slower in last months - https://phabricator.wikimedia.org/T160188#3670432 (10zhuyifei1999) Or make faster :) [19:38:46] 10Quarry: Quarry runs thousands times slower in last months - https://phabricator.wikimedia.org/T160188#3670437 (10IKhitron) >>! In T160188#3670432, @zhuyifei1999 wrote: > Or make faster :) Make faster it's great, but if it's possible that it will make slower, then this task isn't closed forever, I'm affraid. [20:02:27] 10Quarry: Quarry runs thousands times slower in last months - https://phabricator.wikimedia.org/T160188#3670531 (10zhuyifei1999) >>! In T160188#3670437, @IKhitron wrote: > Make faster it's great, but if it's possible that it will make slower, then this task isn't closed forever, I'm affraid. In that case, if on... [20:50:07] 10Quarry: Quarry runs thousands times slower in last months - https://phabricator.wikimedia.org/T160188#3670621 (10IKhitron) Not 5 times, at least 1800 times. I see, thankmyou for this explanation, and for your help, @zhuyifei1999. [22:20:51] https://en.wikipedia.org/wiki/Wikipedia_talk:What_Wikipedia_is_not#Wikipedia_is_Not_a_Laboratory (CC halfak)