BIND 10 #324: improve SQL data source performance

[BIND 10 Development]

#324: improve SQL data source performance
-------------------------------------+-------------------------------------
                   Reporter:  each   |                 Owner:  jinmei
                       Type:         |                Status:  accepted
  enhancement                        |             Milestone:
                   Priority:         |  Sprint-20120403
  medium                             |            Resolution:
                  Component:  data   |             Sensitive:  0
  source                             |           Sub-Project:  DNS
                   Keywords:         |  Estimated Difficulty:  5
  performance                        |           Total Hours:  0
            Defect Severity:  N/A    |
Feature Depending on Ticket:         |
  sqlite schema upgrade              |
        Add Hours to Ticket:  0      |
                  Internal?:  0      |
-------------------------------------+-------------------------------------

Comment (by jinmei):

 this task is now ready for review at branch trac324new2 (it has this
 strange branch name for historical reasons).

 As long as we are okay with the proposed schema change, the content
 of this branch should be basically straightforward.  I've applied
 Stephen's patch, and re-enabled the dbutil part that was temporarily
 disabled.  It contains some additional cleanups.

 The proposed changelog entry is:

 {{{
 416.?   [bug]*          jinmei, stephen
         Updated the DB schema used in the SQLite3 data source so it can
         use SQL indices more effectively.  The previous schema had several
         issues in this sense and could be very slow for some queries on a
         very large zone (especially for negative answers).  This change
         requires a major version up of the schema; use b10-dbutil to
         upgrade existing database files.  Note: 'make install' will fail
         unless old DB files installed in the standard location has been
         upgraded.
         (Trac #324, git TBD)
 }}}

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