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 6439 Apr 14, 2000, 10:15 AM
Post Re: top 5 search terms
pugdog 6376 Apr 14, 2000, 11:33 PM
Post Re: top 5 search terms
Elijanio 6359 Apr 15, 2000, 3:34 PM
Post Re: top 5 search terms
pugdog 6343 Apr 15, 2000, 4:39 PM
Post Re: top 5 search terms
Elijanio 6366 Apr 15, 2000, 5:07 PM
Post Re: top 5 search terms
pugdog 6365 Apr 15, 2000, 5:42 PM
Post Re: top 5 search terms
Elijanio 6388 Apr 15, 2000, 5:51 PM
Post Re: top 5 search terms
pugdog 6357 Apr 15, 2000, 7:54 PM
Post Re: top 5 search terms
Elijanio 6392 Apr 16, 2000, 6:26 AM
Thread Re: top 5 search terms
pugdog 6372 Apr 16, 2000, 7:03 AM
Thread Re: top 5 search terms
Christa 6355 Nov 9, 2000, 12:46 PM
Thread Re: top 5 search terms
pugdog 6325 Nov 9, 2000, 1:30 PM
Thread Re: top 5 search terms
Christa 6318 Nov 9, 2000, 1:52 PM
Thread Re: top 5 search terms
pugdog 6351 Nov 9, 2000, 3:12 PM
Thread Re: top 5 search terms
Christa 6357 Nov 9, 2000, 3:24 PM
Thread Re: top 5 search terms
pugdog 6354 Nov 9, 2000, 6:06 PM
Thread Re: top 5 search terms
Christa 6334 Nov 9, 2000, 7:27 PM
Thread Re: top 5 search terms
pugdog 6305 Nov 9, 2000, 7:31 PM
Thread Re: top 5 search terms
OneDanShow 6337 Nov 9, 2000, 10:27 PM
Thread Re: top 5 search terms
pugdog 6315 Nov 9, 2000, 11:01 PM
Post Re: top 5 search terms
pirl 6284 Nov 10, 2000, 3:27 AM