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 > _______________________________________________ Wiki Loves Monuments mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu
