Thanks :)
Do you mean clear out all your search terms? Or just old ones?
If you want to keep your search terms, so you maintain an all-time "high" list, there isn't much you can do, since the terms are agregated in the Search_Log table, so if you have 39,000 entries in that table, there are 39,000 different terms, not 39,000 searches (following?). If the table kept a list of all the searches, you could delete the x-number of oldest searches, and "freshen" the list a bit. This _will_not_ work with the current implementation.
In the Search_Log_Daily, you can trim that file by
DELETE from Search_Log_Daily Where TDate > 2000-09-30
or similar. That will reset the various sub tables.
If you delete the Search_Log file, your site will re-set, in effect, and you will be starting your "searches" over from '0'. For an established site, that might look funny.
I'll think about this for a little and see if I can come up with a way to make a sort of 'rolling' "top" searches.
That could probably be done by reading the Search_Log_Daily table, going back how ever far you wanted to, then generating a Top_5 or Top_10 list from that, and storing it in a file, and just including that file in.
You could update that file once a month, or whenever it struck you, but you'd still be tracking the all-time top searches, and keeping a daily log.
That may be the best... let me see if I can get that to work :)
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://postcards.com/FAQ
Do you mean clear out all your search terms? Or just old ones?
If you want to keep your search terms, so you maintain an all-time "high" list, there isn't much you can do, since the terms are agregated in the Search_Log table, so if you have 39,000 entries in that table, there are 39,000 different terms, not 39,000 searches (following?). If the table kept a list of all the searches, you could delete the x-number of oldest searches, and "freshen" the list a bit. This _will_not_ work with the current implementation.
In the Search_Log_Daily, you can trim that file by
DELETE from Search_Log_Daily Where TDate > 2000-09-30
or similar. That will reset the various sub tables.
If you delete the Search_Log file, your site will re-set, in effect, and you will be starting your "searches" over from '0'. For an established site, that might look funny.
I'll think about this for a little and see if I can come up with a way to make a sort of 'rolling' "top" searches.
That could probably be done by reading the Search_Log_Daily table, going back how ever far you wanted to, then generating a Top_5 or Top_10 list from that, and storing it in a file, and just including that file in.
You could update that file once a month, or whenever it struck you, but you'd still be tracking the all-time top searches, and keeping a daily log.
That may be the best... let me see if I can get that to work :)
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://postcards.com/FAQ