Re: [Wiki Loves Monuments] API changes - Statistics

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