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

[Klaus Darilion]

Update: I do see that the BEGIN/COMMIT exists in 4.0, but was removed in
Master (4.1pre). That might explain why Master is faster :-)

regards
Klaus

Am 22.09.2017 um 10:35 schrieb Klaus Darilion:
> 
> 
> Am 21.09.2017 um 20:20 schrieb Aki Tuomi:
>> Statements are supposed to prepared once, not per every query.
> 
> Indeed, that is the case, the "prepare" is only done once.
> 
> But I see that simple SELECTs are wrapped into transactions. Maybe this
> is also a performance penalty:
> 
> regards
> Klaus
> 
> 
> LOG:  duration: 0.049 ms  statement: BEGIN
> LOG:  duration: 0.276 ms  bind stmt1506068957225329: SELECT
> content,ttl,prio,type,domain_id,disabled::int,name,auth::int FROM
> records WHERE disabled=false and type=$1 and name=$2
> DETAIL:  parameters: $1 = 'SOA', $2 =
> 'rr-types-dev.rc0-testing.dnssec-signiert.at'
> LOG:  duration: 0.081 ms  execute stmt1506068957225329: SELECT
> content,ttl,prio,type,domain_id,disabled::int,name,auth::int FROM
> records WHERE disabled=false and type=$1 and name=$2
> DETAIL:  parameters: $1 = 'SOA', $2 =
> 'rr-types-dev.rc0-testing.dnssec-signiert.at'
> LOG:  duration: 0.043 ms  statement: COMMIT
> 
> 
> 
> 
> LOG:  duration: 0.042 ms  statement: BEGIN
> LOG:  duration: 0.263 ms  bind stmt1506069237650545: SELECT
> content,ttl,prio,type,domain_id,disabled::int,name,auth::int FROM
> records WHERE disabled=false and type=$1 and name=$2
> DETAIL:  parameters: $1 = 'SOA', $2 =
> 'rr-types-dev.rc0-testing.dnssec-signiert.at'
> LOG:  duration: 0.076 ms  execute stmt1506069237650545: SELECT
> content,ttl,prio,type,domain_id,disabled::int,name,auth::int FROM
> records WHERE disabled=false and type=$1 and name=$2
> DETAIL:  parameters: $1 = 'SOA', $2 =
> 'rr-types-dev.rc0-testing.dnssec-signiert.at'
> LOG:  duration: 0.038 ms  statement: COMMIT
> 
>