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

Re: top 5 search terms

Quote Reply
Re: top 5 search terms In reply to
I just added a bunch of stuff to my search page.

You can check it out here
http://www.postcards.com/...Postcards/search.cgi

These are cgi generated, and yank the information from the database. The speed difference after indexing the "Count" and "Last_Hit" fields was STAGGERING!

I know there have to be better ways of figuring out the dates -- doing date arithmetic -- and things such as the "top_today" and eventually the "top_yesterday" could be coded more elegantly to use less system resources.

By using more tables, and keeping better tabs of what was being looked at, you could generate stats that could be inserted into a side-bar on each build, or into any cgi generated page (or even SSI).


Subject Author Views Date
Thread top 5 search terms pugdog 6100 Apr 14, 2000, 10:15 AM
Post Re: top 5 search terms
pugdog 6048 Apr 14, 2000, 11:33 PM
Post Re: top 5 search terms
Elijanio 6030 Apr 15, 2000, 3:34 PM
Post Re: top 5 search terms
pugdog 6016 Apr 15, 2000, 4:39 PM
Post Re: top 5 search terms
Elijanio 6039 Apr 15, 2000, 5:07 PM
Post Re: top 5 search terms
pugdog 6037 Apr 15, 2000, 5:42 PM
Post Re: top 5 search terms
Elijanio 6057 Apr 15, 2000, 5:51 PM
Post Re: top 5 search terms
pugdog 6029 Apr 15, 2000, 7:54 PM
Post Re: top 5 search terms
Elijanio 6065 Apr 16, 2000, 6:26 AM
Thread Re: top 5 search terms
pugdog 6042 Apr 16, 2000, 7:03 AM
Thread Re: top 5 search terms
Christa 6026 Nov 9, 2000, 12:46 PM
Thread Re: top 5 search terms
pugdog 5994 Nov 9, 2000, 1:30 PM
Thread Re: top 5 search terms
Christa 5989 Nov 9, 2000, 1:52 PM
Thread Re: top 5 search terms
pugdog 6022 Nov 9, 2000, 3:12 PM
Thread Re: top 5 search terms
Christa 6028 Nov 9, 2000, 3:24 PM
Thread Re: top 5 search terms
pugdog 6025 Nov 9, 2000, 6:06 PM
Thread Re: top 5 search terms
Christa 6005 Nov 9, 2000, 7:27 PM
Thread Re: top 5 search terms
pugdog 5976 Nov 9, 2000, 7:31 PM
Thread Re: top 5 search terms
OneDanShow 6008 Nov 9, 2000, 10:27 PM
Thread Re: top 5 search terms
pugdog 5986 Nov 9, 2000, 11:01 PM
Post Re: top 5 search terms
pirl 5956 Nov 10, 2000, 3:27 AM