Hi Nuno,
Looks really good! I added it to the update script
(~erfgoed/bin/update_monuments.sh) so it gets updated once a day.
Maarten
Op 4-9-2011 2:34, Nuno Tavares schreef:
> Guys, just a quick insight into the Statistics API module. Maarten,
> please setup the cron.
>
>
> == Changes ==
> * New table: statistics
> * Changed FormatHtml to allow datasets different than fetchObject()
> * Changed FormatHtml to allow colorizing of _pct fields
> * There was an optional index to monuments_all (idx_ctry_municp) which
> will speed up a little bit, but nothing significat, so I discarded
>
> == Notes ==
> * The stats may be built in RAM or directly into database. Benchmarks below.
> * Repeating myself: there are data quality issues, like multi-valued
> municipalities (max is from 'ro' which is about 500 chars). This means
> the listing will get municipalities cropped, unless field 'idx' is enlarged.
>
>
> == Requirements ==
> * setup cron to run this periodically:
> php -n ~/erfgoed/public_html/maintenance/_buildStats.php
>
> == Benchmarks ==
>
> ntavares@willow:~/p_erfgoed/stats$ time php -n _buildStats.php #
> (bBuildInRAM=false)
> [d] Memory usage: 5769240
>
> real 5m18.498s
> user 0m13.602s
> sys 0m10.129s
>
> ntavares@willow:~/p_erfgoed/maintenance$ time php -n _buildStats.php #
> (bBuildInRAM=true)
> [d] Memory usage: 106251416
>
> real 4m0.019s
> user 0m12.249s
> sys 0m10.346s
>