User talk:Khalil-2016

Welcome to Meta!

Hello, Khalil-2016. Welcome to the Wikimedia Meta-Wiki! This website is for coordinating and discussing all Wikimedia projects. You may find it useful to read our policy page. If you are interested in doing translations, visit Meta:Babylon. You can also leave a note on Meta:Babel or Wikimedia Forum (please read the instructions at the top of the page before posting there). Happy editing!

-- Meta-Wiki Welcome (talk) 13:23, 29 August 2012 (UTC)

Quarry usage

Hi, I noticed that some of your queries may be trying to access huge data, consuming considerable time. It is preferable to limit the records using 'LIMIT' key word in your queries to enable others also to use quarry.As I understand that each query has max time allocation of 30 minutes. Ex query. Example: http://quarry.wmflabs.org/query/6185

USE arwiki_p;
SELECT DATE_FORMAT(log_timestamp,"%Y-%m-%d") AS date, COUNT(*)
FROM logging
WHERE log_action = 'create' AND log_type = 'newusers'
GROUP BY 1
ORDER BY log_timestamp;

Example using Limit: http://quarry.wmflabs.org/query/8418 I am sorry, if in case quarry is slow for other reasons. --Arjunaraoc (talk) 09:51, 27 March 2016 (UTC)

Ijust realized that you are using LIMIT in your other queries. May be you missed with the above query. --Arjunaraoc (talk) 09:56, 27 March 2016 (UTC)