[geeklog-devel] New block on geeklog.net

[Blaine Lang]

I was also thinking, maybe have a script that would remove old download
history records.
- those records for files that are no longer online

I'm using the <tt> tag and I bet they have a css style change for that.

I do store the total downloads for a file but I don't see any other way to
determine the total over the last 24 hours without reading all the download
records. Just looking, we have nearly 143,000 downloadhistory records dating
back to Sept 25 2002 when it was installed.

Maybe keeping only the last 6 months would be a good idea. Should do a
little pruning ?


----- Original Message ----- 
From: "Dirk Haun" <dirk at haun-online.de>
To: <geeklog-devel at lists.geeklog.net>
Sent: Sunday, January 25, 2004 4:41 AM
Subject: Re: [geeklog-devel] New block on geeklog.net


> Blaine wrote:
>
> >It's adding 2-3 seconds to refresh the page now and I've added a couple
> >indexes but it still has a lot of records to crunch thru to calculate
counts.
>
> Ah, so that's why the site felt so slow. I was beginning to wonder ...
>
> I was shocked to see the first line read
>
>     Geeklog 1.3.8-1 (155)
>
> but on closer inspection, that does link to 1.3.8-1sr3, so it's only
> cutting off the file name. However, number 5 on the list is
>
>     Geeklog 1.3.8 (9)
>
> and that is indeed what it says, i.e. 9 people have downloaded the
> original 1.3.8 tarball within the last 24 hours. Looks like it's really
> time for some housecleaning in the downloads area ...
>
>
> Btw, when you go to the FAQ, <http://www.geeklog.net/faqman/>, the
> contents of the block are displayed in italics. Looks like some of the
> FAQ style information is "leaking" into the rest of the site (I've seen
> this happening with other pages, too).
>
> bye, Dirk
>
> -- 
> http://www.haun-online.de/
> http://www.macosx-faq.de/
>
> _______________________________________________
> geeklog-devel mailing list
> geeklog-devel at lists.geeklog.net
> http://lists.geeklog.net/listinfo/geeklog-devel
>