We love Magento at Evohosting–it is a very impressive application with so much functionality; however, with some things Magento is a massive pain. One of the main problems our customers are seeing is that product and stock imports are INCREDIBLY slow, and take up a LOT of CPU usage.
We did some digging and found a nice solution to this, a community member called ‘michael_08’ over at the Magento forums has kindly developed a very nice Magento import script. This will take the import time for products, stock levels etc down to 1% or less of the original time it would take.
Read: Forum thread regarding Magento Import Speed (the code is in the forum thread).
Test the script before running (take a database backup!), you’ll also need to know your Magento database settings and file path settings.