[Pdns-users] /api/v1/servers/localhost/zones api call very slow

[Steve Zeng]

Hi,

We have a few thousands zones (in the table ‘domains') hosted in PowerDNS database (MySQL). it looks very slow (10-12 minutes) to get a list of all domains with API call below:

curl -H 'X-API-Key: mykey' 'http://127.0.0.1:8080/api/v1/servers/localhost/zones/'

Is this a noticed performance problem? 

When I called with "search-data” it looks much faster (a few seconds) with a lot more records (~30 thousands rows in the table ‘records' ).  

pdns-admin]# curl -H 'X-API-Key: mykey' 'http://127.0.0.1:8080/api/v1/servers/localhost/search-data?q=*&max=30000' 

any insight where the slowness comes from?

Thanks,
Steve