Re: [DOC-WEB] cvs: docweb /scripts notes_stats.php

On Tuesday 01 February 2005 18:34, Nuno Lopes wrote:
> nlopess  Tue Feb  1 12:34:44 2005 EDT
>
>   Modified files:
>     /docweb/scripts notes_stats.php
>   Log:
>   major script tuning:
>   improved speed

I don't know your machine, but on mine I only notice that it have to take a 15 
minutes break for the script to finish the query (not counting the download 
time)
and the /www script seems to take 5 seconds instead of 0.25 seconds that the 
orignal version used (on my machine)

Also the huge database it not needed at all, only wasting disk space

ls -l notes_stats.sqlite*
-rw-r--r--    1 Allowee  Allowee   3975168 Feb  3 15:25 notes_stats.sqlite
-rw-r--r--    1 Allowee  Allowee    158720 Jan 31 22:22 notes_stats.sqlite.old

I have to agree that the old version could be improved even more, by only 
inserting the top 20 files instead of all files is a good tweak..

Would be nice to hear why everything has to be changed while the orginal 
version worked quite fine.

Vincent