For a customer i compare sevceral shop systems to find out the best one. The last three days i test magento 18.104.22.168 CE.
I try to import round about 500.000 Products in a Testshop to measure if its possible to use Magento with this number of articles.
First i try to import the Articles with the soapApi. Because it was very very slow (round about 3-6 Seconds per Product with enabled cache) i change it to use direct the Mage api2 (and 1).
Its a little bit faster (approx. 2-3 Secondes per Product) but much to slow (with this speed we need 11 or more Days to import 500.000 Products...and i also have to import Attributes and Images...).
I use a new server for testing (2 Xeon 3.2 GHz, 64 GB Ram, very fast SAS-HDs) and also read the Article about “Tuning innodb performance for Meganto). I also install apc-Cache, tmpfs (for /var).
Why is the import sooo slow (makes it unusable fin my eyes) ? I don’t wan’t to think about the Shop Performance after import....
Is there something i can do to speed it up ? In my eyes the concept of magento (overloading is great solved) is very good. But the perfomance makes it unusable for my customer.
Thanks for any hint.