BIND 10 #324: improve SQL data source performance

[BIND 10 Development]

#324: improve SQL data source performance
-------------------------------------+-------------------------------------
                   Reporter:  each   |                 Owner:  UnAssigned
                       Type:         |                Status:  assigned
  enhancement                        |             Milestone:  Year 3 Task
                   Priority:  major  |  Backlog
                  Component:  data   |            Resolution:
  source                             |             Sensitive:  0
                   Keywords:         |           Sub-Project:  DNS
  performance                        |  Estimated Difficulty:  0.0
            Defect Severity:  N/A    |           Total Hours:  0
Feature Depending on Ticket:         |
  sqlite schema upgrade              |
        Add Hours to Ticket:  0      |
                  Internal?:  0      |
-------------------------------------+-------------------------------------
Changes (by shane):

 * feature:   => sqlite schema upgrade
 * milestone:   => Year 3 Task Backlog


Comment:

 This ticket improves performance and solves a performance regression
 described in #414, but has a design flaw where the schema is updated by
 the server code itself.

 We should have a separate utility to upgrade schema. This is described in
 ticket #963, and that ticket should be completed first.

 This ticket needs to be reworked so that it does not actually perform the
 upgrade if an earlier version is detected.

 Since the changes are performance related, the software should be able to
 run with the previous schema, although with a warning.

 As a final change, the database used for the tests should probably be
 built from a text file of SQL statements rather than shipped as a binary.

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