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:         |                 Owner:
  vorner                             |                Status:  new
                       Type:         |             Milestone:  New Tasks
  defect                             |              Keywords:
                   Priority:         |             Sensitive:  0
  medium                             |           Sub-Project:  DNS
                  Component:  data   |  Estimated Difficulty:  0
  source                             |           Total Hours:  0
               CVSS Scoring:         |
            Defect Severity:  N/A    |
Feature Depending on Ticket:         |
        Add Hours to Ticket:  0      |
                  Internal?:  0      |
-------------------------------------+-------------------------------------
 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.

 Such performance is unusable for any practical purpose for such a large
 zone. I
 thought we fixed such problem by some indices, but it seems it didn't help
 enough.

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