{"action":"opened","issue":{"url":"https://api.github.com/repos/wp-e-commerce/WP-e-Commerce/issues/2067","repository_url":"https://api.github.com/repos/wp-e-commerce/WP-e-Commerce","labels_url":"https://api.github.com/repos/wp-e-commerce/WP-e-Commerce/issues/2067/labels{/name}","comments_url":"https://api.github.com/repos/wp-e-commerce/WP-e-Commerce/issues/2067/comments","events_url":"https://api.github.com/repos/wp-e-commerce/WP-e-Commerce/issues/2067/events","html_url":"https://github.com/wp-e-commerce/WP-e-Commerce/issues/2067","id":139675961,"number":2067,"title":"wpsc-product custom post type admin list can cause out of memory fatal errors","user":{"login":"JeffPyeBrook","id":3098792,"avatar_url":"https://avatars.githubusercontent.com/u/3098792?v=3","gravatar_id":"","url":"https://api.github.com/users/JeffPyeBrook","html_url":"https://github.com/JeffPyeBrook","followers_url":"https://api.github.com/users/JeffPyeBrook/followers","following_url":"https://api.github.com/users/JeffPyeBrook/following{/other_user}","gists_url":"https://api.github.com/users/JeffPyeBrook/gists{/gist_id}","starred_url":"https://api.github.com/users/JeffPyeBrook/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JeffPyeBrook/subscriptions","organizations_url":"https://api.github.com/users/JeffPyeBrook/orgs","repos_url":"https://api.github.com/users/JeffPyeBrook/repos","events_url":"https://api.github.com/users/JeffPyeBrook/events{/privacy}","received_events_url":"https://api.github.com/users/JeffPyeBrook/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-03-09T19:26:10Z","updated_at":"2016-03-09T19:26:10Z","closed_at":null,"body":"Because the wpsc-product custom post type is hierarchical, the admin list table for products will override and posts per page settings request all posts from the database when the list table is first displayed. See wp_edit_posts_query().\r\n\r\nThis causes out of memory fatal errors on sites with large product catalogs or small amounts of memory as each post is read into memory and cached with it's properties and meta. \r\n\r\nEither the hierarchical post type needs to be overridden, or a default sort order needs to be set to avoid the out of memory condition.\r\n\r\nEven when a fatal out of memory condition does not get triggered, this has a easily measurable negative impact on site performance and resource utilization."}}