Hi, I have iSearch module installed in my site, and I have the following problem... it seems as I have too many searches! :)

actually it wouldn't be a problem, but having 2000 searches per day, makes the table grow too much and too fast, and I find a big problem on performance here, as iSearch saves every single and individual query, when doing a top 40 most searched words, only the sql takes like 3 seconds, that is too much! don't you think?

any idea on how can I fix this without rewriting the whole module and creating a couple of tables?

thanks in advance

Hi, marckd,

it's not a bug, it's a feature

iSearch logs every search request, similar to a counter. btw: if a user searches for more than on word in one request, e.g. "xoops module download", iSearch logs these three words individually.

If you have a "narrow" content on your site, there shouldn't be too much words people are looking for, because they mostly search for the same things...

I also use the module, but only as a webmaster tool. It shows me what users are looking for and whether they get it and what they get. So its helpful for optimizing the contents.

There are about 230 word logged for about 300 search requests.

From time to time I remove some words out of the iSearch database. You can do this in the module administration. You can also use the module's blacklist to reduce the database. E.g. avoid logging words like "and, xoops, download" etc, if you don't need this information.

Maybe Hervé can tell you more.

kind regards
markesh/karim

Thanks for replying! I know it is not a bug :) but it is being a problem to me!

There are around 5000 different querys in 300k searches that have been made.

The thing is that I wanted to create a tag cloud, but with so many data, the speed and performance of the site is reduced considerable

Is your navigation inside your site "good enough" ?
If they use too much the search, may be that's because they can't find what they need ?