The words for the keyword can be made up of a sentace, ie 10 or more keywords to one entry.
Also incase I didnt answer before, we are using TSearch2 and all tables have been fully analyzed and indexed.
Any other suggestions?
How long do searches take when 10 000 rows are returned?
We can not use a limit of 100 because we need to analyze the entire data set returned.