Topic on User talk:Magnus Manske

WikiProject Women in Red has been using ListeriaBot with Wikidata list to generate lists of women who have no article on enwiki, and I’ve been learning a bit about Wikidata and SPARQL by helping out.

We’ve come across a seemingly intractable problem, though, with chess players. A WQS query that runs fine (2386 results in 3232 ms) will completely time out when put into the Wikidata list template. Replace chess player (Q10873124) with any other occupation, and the list is created with no problem. Here I plugged in archer (Q13382355). Over here, I tried pianist (Q486748).

Can you shed any light on what is going on? As Tagishsimon said, “I’ve concluded that ListeriaBot just doesn’t like chess players!” Thanks for any help you can give us.

I think I know what it is. Listeria will load all the items from Wikidata via API. If you look at e.g. Vera Jürgens (Q96436), you will notice the giant list of ELO data. That will also get loaded, and parsed. For ~2300 items. That's what's bogging it down. I'll have a look.

OMG, that ELO data...! Shouldn’t that be stashed in an array somewhere instead of directly stored with the item? No wonder ListeriaBot is choking. Thanks for checking it out.