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

2017-09-22 Thread 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

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

2017-09-22 Thread 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

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

2017-09-22 Thread Aki Tuomi
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

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

2017-09-22 Thread 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: dur