> Date: Sun, 4 Sep 2011 15:39:21 +0200
> From: zvandijk@googlemail.com
> To: wikilovesmonuments@lists.wikimedia.org
> Subject: Re: [Wiki Loves Monuments] API changes - Statistics
>
> Hello,
> In the table, language "nl" is attributed to be-wal, is this
> intentional? Besides, it would be useful if the sorting of "image"
> could be done also by %, not only the total number of images.
> Kind regards
> Ziko
>
>
>
> 2011/9/4 Maarten Dammers <maarten@mdammers.nl>:
> > 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
> > WikiLovesMonuments@lists.wikimedia.org
> > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
> > http://www.wikilovesmonuments.eu
> >
>
>
>
> --
> Ziko van Dijk
> The Netherlands
> http://zikoblog.wordpress.com/
>
> _______________________________________________
> Wiki Loves Monuments mailing list
> WikiLovesMonuments@lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
> http://www.wikilovesmonuments.eu