{"action":"created","issue":{"url":"https://api.github.com/repos/cubecart/v6/issues/1345","repository_url":"https://api.github.com/repos/cubecart/v6","labels_url":"https://api.github.com/repos/cubecart/v6/issues/1345/labels{/name}","comments_url":"https://api.github.com/repos/cubecart/v6/issues/1345/comments","events_url":"https://api.github.com/repos/cubecart/v6/issues/1345/events","html_url":"https://github.com/cubecart/v6/issues/1345","id":188228851,"number":1345,"title":"Performance - New DB index","user":{"login":"Noodleyman","id":10614018,"avatar_url":"https://avatars.githubusercontent.com/u/10614018?v=3","gravatar_id":"","url":"https://api.github.com/users/Noodleyman","html_url":"https://github.com/Noodleyman","followers_url":"https://api.github.com/users/Noodleyman/followers","following_url":"https://api.github.com/users/Noodleyman/following{/other_user}","gists_url":"https://api.github.com/users/Noodleyman/gists{/gist_id}","starred_url":"https://api.github.com/users/Noodleyman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Noodleyman/subscriptions","organizations_url":"https://api.github.com/users/Noodleyman/orgs","repos_url":"https://api.github.com/users/Noodleyman/repos","events_url":"https://api.github.com/users/Noodleyman/events{/privacy}","received_events_url":"https://api.github.com/users/Noodleyman/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-11-09T11:49:33Z","updated_at":"2016-11-21T12:13:34Z","closed_at":null,"body":"Adding a new DB index on CubeCart_seo_urls has had a huge improvement in perormance, and also caching capability on one of my larger stores (20k+ products).\r\n\r\nAdding a new index on columns \"type\" and \"item_id\" allows MySQL to use the one index for both of the where conditions in the main SQL query that references the table.  After adding it all of those queries were also being cached where as previously there were not.\r\n\r\nIt's had a MAJOR impact on performance, and I am recommending this be added as part of the ugprader\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/cubecart/v6/issues/comments/261921114","html_url":"https://github.com/cubecart/v6/issues/1345#issuecomment-261921114","issue_url":"https://api.github.com/repos/cubecart/v6/issues/1345","id":261921114,"user":{"login":"abrookbanks","id":4520803,"avatar_url":"https://avatars.githubusercontent.com/u/4520803?v=3","gravatar_id":"","url":"https://api.github.com/users/abrookbanks","html_url":"https://github.com/abrookbanks","followers_url":"https://api.github.com/users/abrookbanks/followers","following_url":"https://api.github.com/users/abrookbanks/following{/other_user}","gists_url":"https://api.github.com/users/abrookbanks/gists{/gist_id}","starred_url":"https://api.github.com/users/abrookbanks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/abrookbanks/subscriptions","organizations_url":"https://api.github.com/users/abrookbanks/orgs","repos_url":"https://api.github.com/users/abrookbanks/repos","events_url":"https://api.github.com/users/abrookbanks/events{/privacy}","received_events_url":"https://api.github.com/users/abrookbanks/received_events","type":"User","site_admin":false},"created_at":"2016-11-21T12:13:34Z","updated_at":"2016-11-21T12:13:34Z","body":"Relates to #1348 & #1346"}}
{"actor":{"display_login":"abrookbanks"}}