Timeline for Tips to speed up the handling of large product collections in backend
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 16, 2015 at 11:42 | comment | added | SR_Magento | I have since implemented an automated script that handles everything outside of the back-end. No more waiting! | |
| Mar 16, 2015 at 11:41 | vote | accept | SR_Magento | ||
| Oct 15, 2014 at 14:40 | comment | added | SR_Magento | I appreciate your thoughts, with those large databases have any of your clients not had the requirement to update the products? Maybe my question isn't worded right. Basically I have a script that updates the products names, descriptions and images with a 3rd party. The developer I hired made it so that I have a drop down to update them. So when I need to update products, I dont want to go by pages of 200. I go 5k, update and walk away. Should I include this in my question? | |
| Oct 15, 2014 at 13:56 | comment | added | Jonathan Hussey | Well it's of course completely up to you how you do things, I'm just offering my thoughts on your best, most efficient course of action. Reading/writing directly to the database which is close to what the export/import process does it always going to be countless times quicker than doing the same through PHP methods. The largest database I have worked with is around 115K products, 800K orders. | |
| Oct 15, 2014 at 10:45 | comment | added | SR_Magento | Going through csv files isn't time efficient either. BTW Whats the largest database you've worked with? | |
| Oct 15, 2014 at 6:40 | comment | added | Jonathan Hussey | Ah right, well if it's mass product editing you are after you should be using the export/import process to do this - far more efficient than working with vast product collections in admin. | |
| Oct 15, 2014 at 0:44 | comment | added | SR_Magento | t would make sense to stick with defaults if I had 5k products, but I have much more. Manipulating large amounts of products by limits of 200 per page is just not an option. I'm sure there is a way to speed this up, thanks for your insight. | |
| Oct 14, 2014 at 19:27 | history | answered | Jonathan Hussey | CC BY-SA 3.0 |