Re: 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