User talk:Kaldari

From Wikipedia, the free encyclopedia
Jump to: navigation, search

Tech News: 2015-32[edit]

15:51, 3 August 2015 (UTC)

Moving Burma to Myanmar - new 2015 poll[edit]

You participated in a Burma RM in the past so I'm informing you of another RM. I hope I didn't miss anyone. New move attempt of Burma>Myanmar Fyunck(click) (talk) 08:42, 7 August 2015 (UTC)

Tech News: 2015-33[edit]

14:58, 10 August 2015 (UTC)

HotArticlesBot MaxArticles 3000?[edit]

I was wondering why this limit is set? It seems to preclude the use of the bot even for comparatively small WPs such as WP:CRO that I just nominated. --Joy [shallot] (talk) 14:54, 11 August 2015 (UTC)

@Joy: The max is only because the database queries for large article sets can be expensive (i.e. can tie up the database for a while). The bot has been disabled in the past for hogging database resources, so I decided it would be better to set a maximum size. The code for the bot was recently improved to be more efficient, however, so I think I'll change the max from 3000 to 10,000 as an experiment. If 10,000 work OK, I'll try increasing it further. Sorry this doesn't accommodate WP:CRO yet though. Stay tuned. Kaldari (talk) 18:28, 11 August 2015 (UTC)
I had a quick look at the code, and when I overcame my dismay at the lack of standard SQL formatting :) I figured that since the limit was imposed on the number of articles in the category, the bottleneck would be in the subquery that extracts data from categorylinks/page tables, right? I noticed that you are retrieving a list of thousands of page_id integers as well as page_title strings there, most of which you're later discarding. Maybe you could speed that up somewhat by having the subquery return only the list of page_id's, and drop the page_title's from there, and then at the end, when you finally reduce the list according to data from recentchanges and $limit, do another query into the page table to resolve just a few page_ids into a few page_titles. --Joy [shallot] (talk) 21:20, 11 August 2015 (UTC)
@Joy: Thanks for the suggestions. If I ever get some free time, I'll try to implement them. Feel free to submit pull requests on Github as well. Sorry about the formatting :) The whole thing is a pretty dirty hack that I did a few years ago and never got around to cleaning up. Kaldari (talk) 21:40, 11 August 2015 (UTC)
Just to make sure, did you ever run any of those queries with EXPLAIN EXTENDED? Maybe they're slow because they need some extra indexes, or if they're formed in a way that misses existing indexes. --Joy [shallot] (talk) 07:52, 12 August 2015 (UTC)

Request for comment[edit]

An editor has asked for a discussion on the deprecation of Template:English variant notice. Since you've had some involvement with the English variant notice template, you might want to participate in the discussion if you have not already done so.Godsy(TALKCONT) 07:11, 14 August 2015 (UTC)

Tech News: 2015-34[edit]

16:17, 17 August 2015 (UTC)

Tech News: 2015-35[edit]

13:02, 24 August 2015 (UTC)

Folger image upload?[edit]

Hi Kaldari,

After an extended wikibreak I've recently returned and saw in the Shakespeare project talk archives a notice from 2012 that the Folger needed help uploading their collection, and suggested contacting you. Do you have any more information about this? Has the uploads been completed? If not, what needs doing? Is anyone working on it? The Folger collections are a gold mine for the Shakespeare project, so this news (albeit somewhat old, sorry) makes me very excited! --Xover (talk) 17:39, 30 August 2015 (UTC)

@Xover: On vacation currently. Will try to look into it when I get back. Kaldari (talk) 18:31, 30 August 2015 (UTC)