BIND 10 #414: huge zone in sqlite3 hangs b10-auth if nxdomain

[BIND 10 Development]

#414: huge zone in sqlite3 hangs b10-auth if nxdomain
-------------------------------------+-------------------------------------
                 Reporter:  jreed    |                Owner:
                     Type:  defect   |               Status:  new
                 Priority:  major    |            Milestone:  A-Team-
                Component:  data     |  Sprint-20110209
  source                             |           Resolution:
                 Keywords:           |            Sensitive:  0
Estimated Number of Hours:  30.0     |  Add Hours to Ticket:  0
                Billable?:  1        |          Total Hours:  0
                Internal?:  0        |
-------------------------------------+-------------------------------------

Comment (by jinmei):

 Replying to [comment:5 shane]:
 > The problem here ends up being an unindexed column. The 'rdtype' column
 on the 'records' table is used in the following lookup:
 [...]
 > The code change is simple (one line in SCHEMA_LIST[]), but we need to
 deal with being able to update the schema. We'll open a separate ticket
 for this, along with collecting a couple more SQL updates in other
 tickets.

 (not directly related to the main topic of this ticket) If you change
 the schema in an incompatible manner, please also reconsider renaming
 'rdtype' to, e.g., 'rrtype'.  "rdtype" is a BIND 9 terminology, which
 has the notion of "rdataset".  Since we are basically handling things
 per RR or per RRset, "rdtype" does not really sound like an appropriate
 name.

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