BIND 10 #2610: Query for large zone in SQLite datasrc takes a very long time

[BIND 10 Development]

#2610: Query for large zone in SQLite datasrc takes a very long time
-------------------------------------+-------------------------------------
            Reporter:  vorner        |                        Owner:
                Type:  defect        |                       Status:  new
            Priority:  medium        |                    Milestone:  New
           Component:  data source   |  Tasks
            Keywords:                |                   Resolution:
           Sensitive:  0             |                 CVSS Scoring:
         Sub-Project:  DNS           |              Defect Severity:  N/A
Estimated Difficulty:  0             |  Feature Depending on Ticket:
         Total Hours:  0             |          Add Hours to Ticket:  0
                                     |                    Internal?:  0
-------------------------------------+-------------------------------------

Comment (by jinmei):

 Replying to [comment:5 jinmei]:

 > > FYI, I just tested a simple query with a very large zone at its apex
 > > and didn't see this problem.  So it may also be related to the
 > > characteristic of your zone data.
 >
 > I guess you created your sqlite3 DB file by (new) b10-loadzone from
 > the scratch.  In this case the creation of the DB and tables are done
 > by sqlite3_accessor, and it doesn't create indexes.

 Sorry, I was confused.  It does create indexes.

 > If my guess is
 > correct, it's quite likely to be the reason for your problem.

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