BIND 10 #2610: Query for large zone in SQLite datasrc takes a very long time

[BIND 10 Development]

#2610: Query for large zone in SQLite datasrc takes a very long time
-------------------------------------+-------------------------------------
            Reporter:  vorner        |                        Owner:
                Type:  defect        |                       Status:  new
            Priority:  medium        |                    Milestone:  New
           Component:  data source   |  Tasks
            Keywords:                |                   Resolution:
           Sensitive:  0             |                 CVSS Scoring:
         Sub-Project:  DNS           |              Defect Severity:  N/A
Estimated Difficulty:  0             |  Feature Depending on Ticket:
         Total Hours:  0             |          Add Hours to Ticket:  0
                                     |                    Internal?:  0
-------------------------------------+-------------------------------------

Comment (by jinmei):

 Replying to [comment:3 jinmei]:

 > > Maybe I wasn't clear in the description. I sent a query. The
 > > server started to eat 100% CPU and then, after working for that 12
 > > seconds, it sent answer (and returned to being idle).

 > > If more than one query is sent in that time, it gets queued in the UDP
 socket
 > > and answered afterwards (after another 12 seconds of hard work).
 > >
 > > So I'm not complaining it would be acting incorrectly. It is just
 incredibly slow.
 >
 > Okay, in that case dumping detailed logs may help diagnose the issue.
 > BTW, I thought we fixed the issue(s) that would have caused this type
 > of performance problem as you mentioned in the ticket description,
 > so I suspect it's a new issue or some kind of regression from the
 > previous fixes.

 FYI, I just tested a simple query with a very large zone at its apex
 and didn't see this problem.  So it may also be related to the
 characteristic of your zone data.

-- 
Ticket URL: <http://bind10.isc.org/ticket/2610#comment:4>
BIND 10 Development <http://bind10.isc.org>
BIND 10 Development