BIND 10 #2699: DHCP performance: use composite search indexes on the lease4 table to improve performance

[BIND 10 Development]

#2699: DHCP performance: use composite search indexes on the lease4 table to
improve performance
-------------------------------------+-------------------------------------
            Reporter:  marcin        |                        Owner:  tmark
                Type:  defect        |                       Status:
            Priority:  high          |  reviewing
           Component:  dhcp4         |                    Milestone:
            Keywords:                |  Sprint-DHCP-20130214
           Sensitive:  0             |                   Resolution:
         Sub-Project:  DHCP          |                 CVSS Scoring:
Estimated Difficulty:  0             |              Defect Severity:
         Total Hours:  0             |  Medium
                                     |  Feature Depending on Ticket:
                                     |          Add Hours to Ticket:  0
                                     |                    Internal?:  0
-------------------------------------+-------------------------------------

Comment (by tmark):

 Created branch trac2699_2 under trac2699 and issued commit --amend to
 prefix comment with branch number per standards.

 I suggest the following entry for ChangeLog:

 [08:39:07] <tomek> git checkout tracA
 5xx.    [func]      team
     Composite key indexes were added to the lease tables to reduce lease
 search time.
     The lease4 table now has two indexes: a) hwaddr/subnet_id and b)
 client_id/subnet_id.
     The lease6 now has the one index: iaid/subnet_id/duid. Adding these
 indexes significantly
     improves lease request performance.
     (Trac #2699,#2703 - git 54bbed5fcbe237c5a49b515ae4c55148723406ce)
 ~

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