{"action":"closed","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4424","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4424/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4424/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4424/events","html_url":"https://github.com/orientechnologies/orientdb/issues/4424","id":90173540,"number":4424,"title":"Query cache","user":{"login":"lvca","id":312606,"avatar_url":"https://avatars.githubusercontent.com/u/312606?v=3","gravatar_id":"","url":"https://api.github.com/users/lvca","html_url":"https://github.com/lvca","followers_url":"https://api.github.com/users/lvca/followers","following_url":"https://api.github.com/users/lvca/following{/other_user}","gists_url":"https://api.github.com/users/lvca/gists{/gist_id}","starred_url":"https://api.github.com/users/lvca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lvca/subscriptions","organizations_url":"https://api.github.com/users/lvca/orgs","repos_url":"https://api.github.com/users/lvca/repos","events_url":"https://api.github.com/users/lvca/events{/privacy}","received_events_url":"https://api.github.com/users/lvca/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/performance","name":"performance","color":"eb6420"}],"state":"closed","locked":false,"assignee":{"login":"lvca","id":312606,"avatar_url":"https://avatars.githubusercontent.com/u/312606?v=3","gravatar_id":"","url":"https://api.github.com/users/lvca","html_url":"https://github.com/lvca","followers_url":"https://api.github.com/users/lvca/followers","following_url":"https://api.github.com/users/lvca/following{/other_user}","gists_url":"https://api.github.com/users/lvca/gists{/gist_id}","starred_url":"https://api.github.com/users/lvca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lvca/subscriptions","organizations_url":"https://api.github.com/users/lvca/orgs","repos_url":"https://api.github.com/users/lvca/repos","events_url":"https://api.github.com/users/lvca/events{/privacy}","received_events_url":"https://api.github.com/users/lvca/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/17","html_url":"https://github.com/orientechnologies/orientdb/milestones/2.2","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/17/labels","id":613160,"number":17,"title":"2.2","description":"","creator":{"login":"lvca","id":312606,"avatar_url":"https://avatars.githubusercontent.com/u/312606?v=3","gravatar_id":"","url":"https://api.github.com/users/lvca","html_url":"https://github.com/lvca","followers_url":"https://api.github.com/users/lvca/followers","following_url":"https://api.github.com/users/lvca/following{/other_user}","gists_url":"https://api.github.com/users/lvca/gists{/gist_id}","starred_url":"https://api.github.com/users/lvca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lvca/subscriptions","organizations_url":"https://api.github.com/users/lvca/orgs","repos_url":"https://api.github.com/users/lvca/repos","events_url":"https://api.github.com/users/lvca/events{/privacy}","received_events_url":"https://api.github.com/users/lvca/received_events","type":"User","site_admin":false},"open_issues":216,"closed_issues":3,"state":"open","created_at":"2014-03-28T13:17:36Z","updated_at":"2015-06-28T21:20:41Z","due_on":"2015-08-09T22:00:00Z","closed_at":null},"comments":6,"created_at":"2015-06-22T18:26:18Z","updated_at":"2015-06-28T21:20:41Z","closed_at":"2015-06-28T21:20:41Z","body":"Many DBMS vendors have a query cache that can be tuned and could be very helpful in case:\r\n- you have a lot of RAM\r\n- the database is mostly read\r\n- you execute the same query over and over again\r\n\r\nReferences:\r\n- **MySQL**: https://dev.mysql.com/doc/refman/5.0/en/query-cache-configuration.html\r\n"}}