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 [ticket:2610 vorner]:
 > I tried loading a large zone into SQLite data source (without the in-
 memory
 > cache, over 3M records). Then I queried for a SOA record of the zone.
 The query
 > got answered correctly, but after something like 12 seconds of b10-auth
 running
 > on 100% CPU.  And my CPU is pretty fast.

 Does this mean you only sent one query (for SOA), b10-auth answered
 it, and then it started eating CPU time (without handling any other
 queries)?  Or did you sent more (same or different) queries, which
 caused the problem?

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