{"action":"created","issue":{"url":"https://api.github.com/repos/SemanticMediaWiki/SemanticMediaWiki/issues/2469","repository_url":"https://api.github.com/repos/SemanticMediaWiki/SemanticMediaWiki","labels_url":"https://api.github.com/repos/SemanticMediaWiki/SemanticMediaWiki/issues/2469/labels{/name}","comments_url":"https://api.github.com/repos/SemanticMediaWiki/SemanticMediaWiki/issues/2469/comments","events_url":"https://api.github.com/repos/SemanticMediaWiki/SemanticMediaWiki/issues/2469/events","html_url":"https://github.com/SemanticMediaWiki/SemanticMediaWiki/issues/2469","id":230122473,"number":2469,"title":"Limit the number of queries allowed per page","user":{"login":"Reasno","id":3881629,"avatar_url":"https://avatars3.githubusercontent.com/u/3881629?v=3","gravatar_id":"","url":"https://api.github.com/users/Reasno","html_url":"https://github.com/Reasno","followers_url":"https://api.github.com/users/Reasno/followers","following_url":"https://api.github.com/users/Reasno/following{/other_user}","gists_url":"https://api.github.com/users/Reasno/gists{/gist_id}","starred_url":"https://api.github.com/users/Reasno/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Reasno/subscriptions","organizations_url":"https://api.github.com/users/Reasno/orgs","repos_url":"https://api.github.com/users/Reasno/repos","events_url":"https://api.github.com/users/Reasno/events{/privacy}","received_events_url":"https://api.github.com/users/Reasno/received_events","type":"User","site_admin":false},"labels":[{"id":98768906,"url":"https://api.github.com/repos/SemanticMediaWiki/SemanticMediaWiki/labels/discussion","name":"discussion","color":"d4c9f9","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2017-05-20T01:45:57Z","updated_at":"2017-05-20T09:30:21Z","closed_at":null,"body":"### Setup and configuration\r\n\r\n- SMW version:2.4.6\r\n- MW version:1.28\r\n- PHP version:HHVM 3.19\r\n- DB (MySQL etc.):MySQL 5.6\r\n\r\n### Issue\r\n\r\nAfter an investigation in the wiki I maintain, I found out the number of queries user made through smw per page is staggering. The most usual abuse is that they want to chain queries in an exponential way. For example: #ask all countries in a page, then #ask all cities in each country and again #ask all members of city councils in each city. \r\n\r\nHaving browsed through Manual: Performance Tuning, I noticed that those tips were more focused on limit complex individual query. In vanilla MediaWiki there are expensive parser function counter which help us to limit db query numbers. I wonder if smw offers something similar? Or if SMW supports expensive parser function counter per se?"},"comment":{"url":"https://api.github.com/repos/SemanticMediaWiki/SemanticMediaWiki/issues/comments/302862229","html_url":"https://github.com/SemanticMediaWiki/SemanticMediaWiki/issues/2469#issuecomment-302862229","issue_url":"https://api.github.com/repos/SemanticMediaWiki/SemanticMediaWiki/issues/2469","id":302862229,"user":{"login":"kghbln","id":1104078,"avatar_url":"https://avatars1.githubusercontent.com/u/1104078?v=3","gravatar_id":"","url":"https://api.github.com/users/kghbln","html_url":"https://github.com/kghbln","followers_url":"https://api.github.com/users/kghbln/followers","following_url":"https://api.github.com/users/kghbln/following{/other_user}","gists_url":"https://api.github.com/users/kghbln/gists{/gist_id}","starred_url":"https://api.github.com/users/kghbln/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kghbln/subscriptions","organizations_url":"https://api.github.com/users/kghbln/orgs","repos_url":"https://api.github.com/users/kghbln/repos","events_url":"https://api.github.com/users/kghbln/events{/privacy}","received_events_url":"https://api.github.com/users/kghbln/received_events","type":"User","site_admin":false},"created_at":"2017-05-20T09:30:21Z","updated_at":"2017-05-20T09:30:21Z","body":"To me integrating with [`$wgExpensiveParserFunctionLimit`](https://www.mediawiki.org/wiki/Manual:$wgExpensiveParserFunctionLimit) or providing a similar SMW related setting appears to be the easiest solution. Once such a limit is reached a semantic wiki will have to knowingly raise the limit and/or deal with ineffective user voodoo regardless who added or uses the queries. Awareness of such an issue on the wiki is thus triggered by the setting."}}
{"actor":{"display_login":"kghbln"}}