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

[BIND 10 Development]

#1756: revise "ITERATE" query in sqlite3_accessor
-------------------------------------+-------------------------------------
                   Reporter:         |                 Owner:  muks
  jinmei                             |                Status:  assigned
                       Type:         |             Milestone:
  defect                             |  Sprint-20120925
                   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):

 Here are some measurements on the `records` table:

 {{{
 32 seconds for insert without index of 299957 records
 -rw-rw-r--   1 muks muks 95246336 Sep 20 15:36 tmp2.sqlite3-without-index

 7 seconds for creating index after inserting records
 -rw-rw-r--   1 muks muks 114114560 Sep 20 15:39 tmp2.sqlite3-with-index-
 after
 ~20% increase in file size

 41 seconds for insert with index of 299957 records
 -rw-rw-r--   1 muks muks 114114560 Sep 20 15:44 tmp2.sqlite3-with-index-
 before
 ~20% increase in file size
 ~28% increase in insert time
 }}}

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