Hi,
Our host has just informed us that we can't change the min word length for our fulltext indexes because we're on a shared hosting plan.
I'm considering ploughing on with my site design and having both FULLTEXT and normal INDEX versions of the same columns until we can afford dedicated hosting. But I'm unsure what the magnitude of the slowdown in the meantime may be.
The database will contain around 500,000 job adverts so if someone types in 'php' (min word length is 4) roughly how long would it take to do a search using the standard index?
If it will take a very long time are there any other solutions that would speed things up?
Thanks for your help!
Regards,
Stu
