This script updates 1000's new relevent keywords matching them to relevant campaigns so advertisers can bid on. The script was currently created with poor database queries and when the script runs via a cron job, its takes too long to update and uses up a lot of cpu resources. I would like someone who has expert sql knowledge and experiences in writing fast database queries in php to update the sql queries where needed so that the script updates very fast and can be use to updated thousands if not millions of keywords to campaigns.
I have added the related scripts so that you can see whats needed.
Need this updated asap.
The [url removed, login to view] is primiary the one that updates everything.
I also need a perl script set to run daily in cron. This one is simple.