BIND 10 #1899: performance issue of SQLite3 "iterate" query (w/ or w/o NSEC3)

[BIND 10 Development]

#1899: performance issue of SQLite3 "iterate" query (w/ or w/o NSEC3)
-------------------------------------+-------------------------------------
                   Reporter:         |                 Owner:  vorner
  jinmei                             |                Status:  reviewing
                       Type:         |             Milestone:
  defect                             |  Sprint-20121009
                   Priority:         |            Resolution:
  medium                             |             Sensitive:  0
                  Component:  data   |           Sub-Project:  DNS
  source                             |  Estimated Difficulty:  6
                   Keywords:         |           Total Hours:  0
            Defect Severity:         |
  Medium                             |
Feature Depending on Ticket:         |
        Add Hours to Ticket:  0      |
                  Internal?:  0      |
-------------------------------------+-------------------------------------
Changes (by muks):

 * owner:  muks => vorner


Comment:

 Hi vorner

 * The unique constraint on NSEC3 owner per zone is now removed
 * NSEC3 RRSIGs are now returned next to their RR set
 * Test was adjusted to check for RRSIGs too

 This still doesn't add or have existing indexes for queries like the first
 half of the union on the `records` table (bug #1756), or index on
 `zone_id` column used in queries.

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