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
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
The language is the language of the objects in the database. Wallonia has nl because the lists are on the dutch wiki and the lists are in dutch.
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
Hi Ziko,
Op 4-9-2011 15:39, Ziko van Dijk schreef:
Hello, In the table, language "nl" is attributed to be-wal, is this intentional?
That's just the language wiki I got the information from. I also had be-wal set up in French put some French admin deleted all the lists.
Besides, it would be useful if the sorting of "image" could be done also by %, not only the total number of images.
The html table output format should probably have a sortable css class attached to it (just like we have at https://secure.wikimedia.org/wikipedia/commons/wiki/Commons:Wiki_Loves_Monum...). Anyone feel like implementing that?
Maarten
I feel, thus I exist :))) lol It's done.
wikilovesmonuments@lists.wikimedia.org