Hey Guys,
I have a PHP script that scraps some sort of information (I will be more clear in PMs)... the scripts require crons to run and come of them to run every minute. the problem is: the source code is written in a way that is VERY VERY much CPU intensive, I have it of Dual Xeons and 12 gigs of RAM dedicated server and they take the CPU up to 11 !!! the CPU should be at 0.5 MAX. they do a lot of HOLD to the MySql requests.
I will provide the Source code, and the DB Structure, and I will provide a screen shot of the Crons running (the times of the crons)
I want you to tell me what can you do to optimize the code? and if I asked to add more services to scrape, will you be able to do it?
Main aim of the project is: OPTIMIZATION. I will only release the funds from Escrow after making sure that it has been optimized on my server.
Thanks
PHP Programmer, having 5 years extensive experience developing applications in PHP. I have a firm command over MySQL Query optimization and I am sure, this is required for your script to work without much server load. Looking forward to hear from you.