Re: [Pdns-users] pdns ddns Performance

2016-03-09 Thread Ruben d'Arco
Thanks for the update! It makes sense. I've logged this as ticket 3528, so somebody could have a look at that subzone query behaviour a bit better. On Tue, Mar 08, 2016 at 09:40:57PM +0100, Thomas Mieslinger wrote: > Hi, > > maybe you remember my message regarding suboptimal ddns update perform

[Pdns-users] pdns ddns Performance

2016-03-08 Thread Thomas Mieslinger
Hi, maybe you remember my message regarding suboptimal ddns update performance. A colleague helped me to identify the list_subzone_query as the performance killer. The original where clause is disabled=0 and (name='%s' OR name like '%s') and domain_id='%d' with %. as second argument. Wh