{"action":"created","issue":{"url":"https://api.github.com/repos/Sylius/Sylius/issues/2860","repository_url":"https://api.github.com/repos/Sylius/Sylius","labels_url":"https://api.github.com/repos/Sylius/Sylius/issues/2860/labels{/name}","comments_url":"https://api.github.com/repos/Sylius/Sylius/issues/2860/comments","events_url":"https://api.github.com/repos/Sylius/Sylius/issues/2860/events","html_url":"https://github.com/Sylius/Sylius/issues/2860","id":87906901,"number":2860,"title":"Out of memory with lots of variants - loading /administration/products/","user":{"login":"msumme","id":462931,"avatar_url":"https://avatars.githubusercontent.com/u/462931?v=3","gravatar_id":"","url":"https://api.github.com/users/msumme","html_url":"https://github.com/msumme","followers_url":"https://api.github.com/users/msumme/followers","following_url":"https://api.github.com/users/msumme/following{/other_user}","gists_url":"https://api.github.com/users/msumme/gists{/gist_id}","starred_url":"https://api.github.com/users/msumme/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/msumme/subscriptions","organizations_url":"https://api.github.com/users/msumme/orgs","repos_url":"https://api.github.com/users/msumme/repos","events_url":"https://api.github.com/users/msumme/events{/privacy}","received_events_url":"https://api.github.com/users/msumme/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Sylius/Sylius/labels/Bug","name":"Bug","color":"e10c02"},{"url":"https://api.github.com/repos/Sylius/Sylius/labels/Critical","name":"Critical","color":"FF8E3D"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/Sylius/Sylius/milestones/7","html_url":"https://github.com/Sylius/Sylius/milestones/v1.0.0-ALPHA1","labels_url":"https://api.github.com/repos/Sylius/Sylius/milestones/7/labels","id":1104570,"number":7,"title":"v1.0.0-ALPHA1","description":"First alpha version of Sylius platform.","creator":{"login":"pjedrzejewski","id":614970,"avatar_url":"https://avatars.githubusercontent.com/u/614970?v=3","gravatar_id":"","url":"https://api.github.com/users/pjedrzejewski","html_url":"https://github.com/pjedrzejewski","followers_url":"https://api.github.com/users/pjedrzejewski/followers","following_url":"https://api.github.com/users/pjedrzejewski/following{/other_user}","gists_url":"https://api.github.com/users/pjedrzejewski/gists{/gist_id}","starred_url":"https://api.github.com/users/pjedrzejewski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pjedrzejewski/subscriptions","organizations_url":"https://api.github.com/users/pjedrzejewski/orgs","repos_url":"https://api.github.com/users/pjedrzejewski/repos","events_url":"https://api.github.com/users/pjedrzejewski/events{/privacy}","received_events_url":"https://api.github.com/users/pjedrzejewski/received_events","type":"User","site_admin":false},"open_issues":3,"closed_issues":43,"state":"open","created_at":"2015-05-11T11:11:16Z","updated_at":"2016-10-20T11:12:41Z","due_on":null,"closed_at":null},"comments":8,"created_at":"2015-06-13T02:14:50Z","updated_at":"2016-10-20T11:12:41Z","closed_at":"2016-10-20T11:12:41Z","body":"I have a shop where each product will have ~1000 variants (3 option sets all of which apply to each product in almost every combination).\r\n\r\nI noticed that I cannot load the /administration/products page as it runs out of memory (128M).\r\n\r\nI was looking into the EXTRA_LAZY associations from Doctrine to see if that might help, but unfortunately it will not currently, as the \"hasVariants\" functionality relies on getVariants(), which in turn calls \"filter()\" on the Collection, requiring every element to be loaded from the database.\r\n\r\nThis is not scalable to large complex stores, unfortunately.\r\n\r\nWhen I have those products loaded, I cannot even load the home page of the web store. \r\n\r\nThis is a problem with the variant model in general - it doesn't scale well for made to order products that have a lot of custom option combinations.  In our particular case, the options (materials we can use) change over time, making the store even harder to manage with the variant model.\r\n\r\nSo - I guess other than the bug report, I was wondering if there were any suggestions for my use case that don't use variants?  I couldn't get the products to add to the cart properly w/o variants, unfortunately, so I'm not really sure what the right way to handle this is.\r\n\r\nAny help would be appreciated."},"comment":{"url":"https://api.github.com/repos/Sylius/Sylius/issues/comments/255077398","html_url":"https://github.com/Sylius/Sylius/issues/2860#issuecomment-255077398","issue_url":"https://api.github.com/repos/Sylius/Sylius/issues/2860","id":255077398,"user":{"login":"pjedrzejewski","id":614970,"avatar_url":"https://avatars.githubusercontent.com/u/614970?v=3","gravatar_id":"","url":"https://api.github.com/users/pjedrzejewski","html_url":"https://github.com/pjedrzejewski","followers_url":"https://api.github.com/users/pjedrzejewski/followers","following_url":"https://api.github.com/users/pjedrzejewski/following{/other_user}","gists_url":"https://api.github.com/users/pjedrzejewski/gists{/gist_id}","starred_url":"https://api.github.com/users/pjedrzejewski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pjedrzejewski/subscriptions","organizations_url":"https://api.github.com/users/pjedrzejewski/orgs","repos_url":"https://api.github.com/users/pjedrzejewski/repos","events_url":"https://api.github.com/users/pjedrzejewski/events{/privacy}","received_events_url":"https://api.github.com/users/pjedrzejewski/received_events","type":"User","site_admin":false},"created_at":"2016-10-20T11:12:41Z","updated_at":"2016-10-20T11:12:41Z","body":"Should be fixed in new admin."}}
{"actor":{"display_login":"pjedrzejewski"}}