Need to improve the relevant keyword php script.
The current script takes keywords that have been generated for each campaign in our database. The script [url removed, login to view] takes each one of these keywords one by one and searches qa_keywords using special conditions to find matches in database of over 540,000 keywords and growing.
It then stores these keyword on campaign table under relevant keywords so advertisers can bid on them.
The problem is it collecting relevant keywords as expected.
Here are the conditions?
The conditions of what results we store are determine in admin. Example lets say we are searching qa_keywords for “high school”. In admin, we set for 2 word keywords, return results no more than 3 keywords.
So results can be if found,
· central high school
· High school bands
· High school
The Problem is to optimize the search function of how it search for keywords. It needs to produce results as intended.
I think the script searches in database using the like function in stead of exact. I was told that the exact function takes longer. I think this is why some of the results I receive are not relevant.