Geezzee.. I actually talked about this probably a year ago :)
There are a lot of problems with that.
have you looked and seen if there are a lot of duplicate searches? What percentage of searches you get that are the same, per unit time?
My top_5 keyword mod does daily tracking of keywords (by calendar day), and you can use the database it generates to find out what your top searches are, and if it pays to consider doing something like that.
I was thinking about this problem about a year ago, you might want to search through the forums here to see what was said about it. Might give you some other ideas. The context was in over all database performance.
When I look at my searches, there are a few that do occur regularly, and I could proabably pre-generate them, and just hard-link to them, but that number is small enough that it doesn't pay (yet) for me. It's amazing what people do look for, and it's all the people looking for 'sex' 'porno' 'nude' 'naked girls' etc, that chew up all the search time. I have 10-15 bogus searches for each "real" search (by keyword, not number). I was looking at the search logs for some of my sites yesterday, and was just shocked!
I need to spiff up the top_xx keywords module, to merge it into one unit that returns all the requested searches, but which also does a regex exclusion on a "bad words" list to get rid of all the x-rated and obscene searches people do.
I have almost all family sites (postcards, photos, links, etc), and "sex" is still the #1 keyword on most of them. Scarey. (oddly, on the two sites that are more targeted to adults, 'sex' is _NOT_ the #1 keyword <G>)
PUGDOGŪ PUGDOGŪ Enterprises, Inc.
FAQ: http://postcards.com/FAQ