[Pdns-users] pdns ddns Performance
cyclops-pdns at prof-x.net
Wed Mar 9 08:59:14 UTC 2016
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:
> maybe you remember my message regarding suboptimal ddns update performance.
> A colleague helped me to identify the list_subzone_query as the performance
> The original where clause is
> disabled=0 and (name='%s' OR name like '%s') and domain_id='%d'
> as second argument.
> When like is used with a search argument that starts with a wildcard the
> index can not be used.
> Because I know that my records to update have no subzones I short circuit
> query with
> SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE
> disabled=0 and (name='%s' OR 'x'='%s') and domain_id='%d'
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
More information about the Pdns-users