Speed up loops through sites
Perhaps access the MariaDB database directly:
SELECT JSON_ARRAYAGG(JSON_OBJECT('idsite', idsite, 'main_url', main_url)) FROM matomo_site
Returns:
[
{
"idsite": 1,
"main_url": "http://wsh.webarchitects.org.uk"
},
{
"idsite": 2,
"main_url": "http://wiki.wsh.webarchitects.org.uk"
},
{
"idsite": 3,
"main_url": "http://www2.weblog.wsh.webarch.org.uk"
}
]
And:
SELECT JSON_ARRAYAGG(JSON_OBJECT('idsite', idsite, 'url', url)) FROM matomo_site_url
Returns:
[
{
"idsite": 2,
"url": "http://wiki.mediawiki.wsh.webarchitects.org.uk"
},
{
"idsite": 2,
"url": "http://www.mediawiki.wsh.webarchitects.org.uk"
},
{
"idsite": 3,
"url": "http://weblog.wsh.webarch.org.uk"
},
{
"idsite": 3,
"url": "http://weblog.wsh.webarchitects.org.uk"
},
{
"idsite": 3,
"url": "http://www.weblog.wsh.webarch.org.uk"
},
{
"idsite": 3,
"url": "http://www.weblog.wsh.webarchitects.org.uk"
}
]