BIND 10 #1756: revise "ITERATE" query in sqlite3_accessor

[BIND 10 Development]

#1756: revise "ITERATE" query in sqlite3_accessor
-------------------------------------+-------------------------------------
                   Reporter:         |                 Owner:  muks
  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:  N/A    |
Feature Depending on Ticket:         |
        Add Hours to Ticket:  0      |
                  Internal?:  0      |
-------------------------------------+-------------------------------------

Comment (by muks):

 We do need to return RRs of the same type consecutively for the iterator
 to put in a single `RRset` when `separate_rrs=false`. We cannot remove
 that `ORDER BY`. So we should have this key unless we want iteration to
 remain slow with large zones.

 Jinmei has replied to the mailing list that he's going to change the way
 RRTypes are stored from text to integer. This would indeed make key
 comparison faster, and hence insertions faster. We can wait and try this
 then.

 I don't like moving the RRType sorting within the iterator itself, as
 that'd involve sorting it every time the iterator is used rather than just
 once.

 This bug remains blocked.

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