Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Re: top 5 search terms

Quote Reply
Re: top 5 search terms In reply to
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


Subject Author Views Date
Thread top 5 search terms pugdog 6329 Apr 14, 2000, 10:15 AM
Post Re: top 5 search terms
pugdog 6270 Apr 14, 2000, 11:33 PM
Post Re: top 5 search terms
Elijanio 6253 Apr 15, 2000, 3:34 PM
Post Re: top 5 search terms
pugdog 6238 Apr 15, 2000, 4:39 PM
Post Re: top 5 search terms
Elijanio 6261 Apr 15, 2000, 5:07 PM
Post Re: top 5 search terms
pugdog 6259 Apr 15, 2000, 5:42 PM
Post Re: top 5 search terms
Elijanio 6279 Apr 15, 2000, 5:51 PM
Post Re: top 5 search terms
pugdog 6251 Apr 15, 2000, 7:54 PM
Post Re: top 5 search terms
Elijanio 6287 Apr 16, 2000, 6:26 AM
Thread Re: top 5 search terms
pugdog 6265 Apr 16, 2000, 7:03 AM
Thread Re: top 5 search terms
Christa 6249 Nov 9, 2000, 12:46 PM
Thread Re: top 5 search terms
pugdog 6218 Nov 9, 2000, 1:30 PM
Thread Re: top 5 search terms
Christa 6212 Nov 9, 2000, 1:52 PM
Thread Re: top 5 search terms
pugdog 6246 Nov 9, 2000, 3:12 PM
Thread Re: top 5 search terms
Christa 6251 Nov 9, 2000, 3:24 PM
Thread Re: top 5 search terms
pugdog 6249 Nov 9, 2000, 6:06 PM
Thread Re: top 5 search terms
Christa 6228 Nov 9, 2000, 7:27 PM
Thread Re: top 5 search terms
pugdog 6199 Nov 9, 2000, 7:31 PM
Thread Re: top 5 search terms
OneDanShow 6231 Nov 9, 2000, 10:27 PM
Thread Re: top 5 search terms
pugdog 6210 Nov 9, 2000, 11:01 PM
Post Re: top 5 search terms
pirl 6178 Nov 10, 2000, 3:27 AM