1
I searched and couldn't find anything so here's a new thread.
It's conceivable that as my XOOPS site grows, more articles are published and search engine traffic increases, more and more people will utilize the search feature. While there are lots of good reasons for searche results to be dynamic, some sites just don't change all that much. For those sites, it seems like search keyword caching might be a good idea to reduce db queries/mysql server load.
For example, perhaps the top search on my XOOPS site each week is "car club". Instead of asking the db to spit out a new results page each time, how about a module that caches the search results for that key phrase for a specified period of time? There's no need to cache every tiny search. Maybe just the top 10. The number of cached terms and the cache time should be selectable. Caching should only occur for the specified terms during the first search for those terms if the cache period has expired for that term.
Doesn't sound like it would be that hard to do. Perhaps borrow from the built-in module caching feature?
"I'm going to see if this internet thing takes off" - someone told me this when I suggested he needed a website.