User talk:Pasleim/Language statistics for items

Total

@Pasleim: Could you add a row at the bottom with totals for labels, descriptions and aliases? Emijrp (talk) 20:59, 19 February 2017 (UTC)

@Pasleim: Have you published the bot code that updates this page? I would like to contribute and code myself the total rows. Emijrp (talk) 16:15, 4 July 2017 (UTC)

Update

No update yesterday, like every Sunday? Emijrp (talk) 08:44, 20 March 2017 (UTC)

@Pasleim: I am also curious; seeing as this no longer works and this never seems to load, I have to rely on this for such information. Mahir256 (talk) 06:21, 24 March 2017 (UTC)

I miss it too. Stryn (talk) 13:42, 27 March 2017 (UTC)

@Pasleim: any reason why there are no recent updates? Sjoerd de Bruin (talk) 15:43, 9 May 2017 (UTC)

The SQL query times out. Don't know if the server settings were changed or if the query needs longer to execute as there are more terms. --Pasleim (talk) 15:46, 9 May 2017 (UTC)

That's a pity. I think the amount of terms is getting too much, yes. Sjoerd de Bruin (talk) 15:50, 9 May 2017 (UTC)

@Pasleim: Does a query for these statistics for a single language (rather than all which Wikidata supports) also time out? If this is the case, how may I run it myself? Mahir256 (talk) 20:28, 20 May 2017 (UTC)

@Pasleim: Never mind the above, I worked out this instead. Given that PLbot fails when attempting to find these stats for all languages, is it possible to split up the bot's workload (say, one-seventh of the languages each day instead of all languages once a week) to prevent time-outs? Mahir256 (talk) 07:32, 22 May 2017 (UTC)

Update (again)

@Pasleim: This hasn't been updated in two weeks. Is the query timing out again? Mahir256 (talk) 02:19, 14 June 2019 (UTC)

This statistics was out of updates since May. --Taravyvan Adijene (talk) 06:51, 24 July 2019 (UTC)

@Pasleim: When I ran this query on tools-dev/login, it took about three hours for output to come back based on the wall clock time. Not sure how long you've set PLbot to run it, but could you perhaps make it run for longer? Mahir256 (talk) 00:05, 26 August 2019 (UTC)

@Pasleim: I ran this query again on tools-dev/login and it took about two and a half hours. Is there any chance PLbot could be set up to run the query for this long in order to regenerate the table? Mahir256 (talk) 03:50, 25 September 2019 (UTC)

@Pasleim, Mahir256: I have created User:Mr. Ibrahem/Language statistics for items based on wikibase dumps .. --Mr. Ibrahem (talk) 15:43, 24 May 2020 (UTC)

Thanks! I've created a redirect to your page. --Pasleim (talk) 17:25, 24 May 2020 (UTC)