{"action":"created","issue":{"url":"https://api.github.com/repos/wp-e-commerce/WP-e-Commerce/issues/1894","labels_url":"https://api.github.com/repos/wp-e-commerce/WP-e-Commerce/issues/1894/labels{/name}","comments_url":"https://api.github.com/repos/wp-e-commerce/WP-e-Commerce/issues/1894/comments","events_url":"https://api.github.com/repos/wp-e-commerce/WP-e-Commerce/issues/1894/events","html_url":"https://github.com/wp-e-commerce/WP-e-Commerce/issues/1894","id":82455521,"number":1894,"title":"Loads of DB queries to wpsc_get_meta() for country data","user":{"login":"benhuson","id":765285,"avatar_url":"https://avatars.githubusercontent.com/u/765285?v=3","gravatar_id":"","url":"https://api.github.com/users/benhuson","html_url":"https://github.com/benhuson","followers_url":"https://api.github.com/users/benhuson/followers","following_url":"https://api.github.com/users/benhuson/following{/other_user}","gists_url":"https://api.github.com/users/benhuson/gists{/gist_id}","starred_url":"https://api.github.com/users/benhuson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/benhuson/subscriptions","organizations_url":"https://api.github.com/users/benhuson/orgs","repos_url":"https://api.github.com/users/benhuson/repos","events_url":"https://api.github.com/users/benhuson/events{/privacy}","received_events_url":"https://api.github.com/users/benhuson/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/wp-e-commerce/WP-e-Commerce/milestones/7","html_url":"https://github.com/wp-e-commerce/WP-e-Commerce/milestones/4.0","labels_url":"https://api.github.com/repos/wp-e-commerce/WP-e-Commerce/milestones/7/labels","id":234069,"number":7,"title":"4.0","description":"Primary focus for this release:\r\n\r\n## Major\r\n##### (Headline changes that would be sad to punt.)\r\n* Integrate new theme engine (#848, #1600, #1263)\r\n* Add Package/Grouped Product Type (#386)\r\n* Make Store Reports and extensible API (#462)\r\n* Recurring Sales API (#83)\r\n\r\n## Minor\r\n##### (General improvements, completed iterations on prior enhancements, etc.  Avoid punting if possible)\r\n* Improved Stock Level handling (#720)\r\n* Add an upgraded_from option (#1569)\r\n\r\n## Iterative\r\n##### (Feature-as-plugins, minor enhancements.  happy to punt.)\r\n* Stats-API improvements (#739)\r\n* REST API (#406)","creator":{"login":"JustinSainton","id":1168754,"avatar_url":"https://avatars.githubusercontent.com/u/1168754?v=3","gravatar_id":"","url":"https://api.github.com/users/JustinSainton","html_url":"https://github.com/JustinSainton","followers_url":"https://api.github.com/users/JustinSainton/followers","following_url":"https://api.github.com/users/JustinSainton/following{/other_user}","gists_url":"https://api.github.com/users/JustinSainton/gists{/gist_id}","starred_url":"https://api.github.com/users/JustinSainton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JustinSainton/subscriptions","organizations_url":"https://api.github.com/users/JustinSainton/orgs","repos_url":"https://api.github.com/users/JustinSainton/repos","events_url":"https://api.github.com/users/JustinSainton/events{/privacy}","received_events_url":"https://api.github.com/users/JustinSainton/received_events","type":"User","site_admin":false},"open_issues":30,"closed_issues":60,"state":"open","created_at":"2012-12-22T23:13:36Z","updated_at":"2015-06-17T21:06:39Z","due_on":"2014-12-29T08:00:00Z","closed_at":null},"comments":16,"created_at":"2015-05-29T14:40:07Z","updated_at":"2015-06-17T21:16:38Z","closed_at":null,"body":"I'm seeing loads of DB queries to wpsc_get_meta() which look like it's to get region country info - about 250 queries!\r\n\r\n```\r\nSELECT `meta_value`\r\nFROM `lmc_wp_wpsc_meta`\r\nWHERE `object_type` = 'WPSC_Country'\r\nAND `object_id` = 241\r\nAND `meta_key` = 'region_label'\r\n```\r\n\r\nIt's happening on every page so may be related to #1845\r\n\r\nHaven't tracked down where it's coming from but it would seem that whatever is doing this could be done more efficiently as a single query for all country data.\r\n\r\nThis is on development for a production site using WPEC 3.9.3, theme engine v1.  \r\nI have not yet tested on trunk.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/wp-e-commerce/WP-e-Commerce/issues/comments/112951803","html_url":"https://github.com/wp-e-commerce/WP-e-Commerce/issues/1894#issuecomment-112951803","issue_url":"https://api.github.com/repos/wp-e-commerce/WP-e-Commerce/issues/1894","id":112951803,"user":{"login":"JustinSainton","id":1168754,"avatar_url":"https://avatars.githubusercontent.com/u/1168754?v=3","gravatar_id":"","url":"https://api.github.com/users/JustinSainton","html_url":"https://github.com/JustinSainton","followers_url":"https://api.github.com/users/JustinSainton/followers","following_url":"https://api.github.com/users/JustinSainton/following{/other_user}","gists_url":"https://api.github.com/users/JustinSainton/gists{/gist_id}","starred_url":"https://api.github.com/users/JustinSainton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JustinSainton/subscriptions","organizations_url":"https://api.github.com/users/JustinSainton/orgs","repos_url":"https://api.github.com/users/JustinSainton/repos","events_url":"https://api.github.com/users/JustinSainton/events{/privacy}","received_events_url":"https://api.github.com/users/JustinSainton/received_events","type":"User","site_admin":false},"created_at":"2015-06-17T21:16:38Z","updated_at":"2015-06-17T21:16:38Z","body":"sorry, got a little trigger happy :P"}}