[Pdns-users] Performance drop after upgrade from auth 3.4.11 to 4.0.4

[Klaus Darilion]

Am 22.09.2017 um 10:43 schrieb Aki Tuomi:
> To my inexpert eye it seems that in your original post, 4.1 was fastest
> of the lot, so the database begin/commit + prepare cannot really explain
> this since this has not been removed in 4.1?

Obviously there were some changes - no more BEGIN/COMMIT

2017-09-22 08:46:37 GMT LOG:  duration: 0.186 ms  execute stmt1: SELECT
content,ttl,prio,type,domain_id,disabled::int,name,auth::int FROM
records WHERE disabled=false and type=$1 and name=$2
2017-09-22 08:46:37 GMT DETAIL:  parameters: $1 = 'SOA', $2 =
'rr-types-dev.rc0-testing.dnssec-signiert.at'

2017-09-22 08:46:38 GMT LOG:  duration: 0.339 ms  bind stmt1: SELECT
content,ttl,prio,type,domain_id,disabled::int,name,auth::int FROM
records WHERE disabled=false and type=$1 and name=$2
2017-09-22 08:46:38 GMT DETAIL:  parameters: $1 = 'SOA', $2 =
'rr-types-dev.rc0-testing.dnssec-signiert.at'



regards
Klaus