Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merge article used and unique used query #5

Closed
wants to merge 1 commit into from

Conversation

maskaravivek
Copy link
Member

@maskaravivek maskaravivek commented Nov 30, 2018

Fixes #4

Unable to test it. @urbanecm need your help in testing the same.

@maskaravivek
Copy link
Member Author

So many lines are showing as changes because of formatting.

@urbanecm
Copy link
Collaborator

urbanecm commented Dec 5, 2018

Looks it takes too long

`
MariaDB [commonswiki_p]> select count(*) as articlesUsing, count(distinct gil_to) as uniqueUsed from globalimagelinks where gil_to in (select log_title from logging_userindex where log_type="upload" and log_user=(select user_id from user where user_name="Ainali"));
+---------------+------------+
| articlesUsing | uniqueUsed |
+---------------+------------+
| 556184 | 1132 |
+---------------+------------+
1 row in set (1 min 19.45 sec)

MariaDB [commonswiki_p]>
`

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Use a single query for fetching articles using images and unique used images
2 participants