Question

MySQL and PHP server for product import

Posted December 1, 2013 2.3k views
Hi, Now I have PHP scripts for product import from vendors, but hostings really make imports too long. So I want to create VPS, install OS, free control panel for cronjobs, PHP, SQL. VPS will update products 6 times a day (create new ones), and update qty and price every 15 minutes. So I can connect from my shop in hosting, and add product by ID or category...etc. What can you recommend for setup in VPS, need fast solution, becose there is 25'000 products.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer
You should be fine with a $5 droplet, so long as you add swap and memcache.
by Etel Sverdlov
Memcache is a system that works to speed up virtual private servers by caching server information. The program allows you to allocate a specific amount of the server ram toward caching recently queried data for a certain amount of time. This tutorial covers Memcache installation and illustrates how to use memcache with a simple php script.
Submit an Answer