Help needed.. We had working (but really heavy cron job script) Oscommerce XML integration to our wholesaler database before (Product info, warehouse qty, categories etc.) Wholesaler made changes their server connection settings and we had to modificate script again. Now the new script is ready and working in test server, but the problem is that it is too heavy to our webserver to handle. (We have try to change all limits but no help).
It disconnects MySQL server after ~10minutes every time. (1.3 million lines and ~200mb data). Now need some help to modificate or split the code or what is the best solution.
Code is english documented and commented.
