On 22.09.2017 11:35, Klaus Darilion wrote: > > 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 > >
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? Aki _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
