[fdo-trac] #383: SDF: Optimize "in" conditions in select filters.

[FDO]

#383: SDF: Optimize "in" conditions in select filters.
----------------------------------------------+-----------------------------
 Reporter:  brentrobinson                     |         Owner:  brentrobinson
     Type:  enhancement                       |        Status:  closed       
 Priority:  major                             |     Milestone:               
Component:  SDF Provider                      |       Version:  3.3.1        
 Severity:  2                                 |    Resolution:  fixed        
 Keywords:  SDF in filter performance select  |   External_id:               
----------------------------------------------+-----------------------------
Comment (by brentrobinson):

 Performance tested using sdf file containing 785,000 features.

 For the following filter:

         PK1 in ( 200000.0 )


 the before and after times were as follows.

                         Time (sec)
         Disk Caching       Before                  After
         ---------------    ----------              ----------
         No                 8.687                   0.016
         Yes                0.844                   < 0.001

 Disk Caching = No was when the SDF file had not yet been put into the disk
 cache, at the start of the test.

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/383#comment:3>
FDO <http://fdo.osgeo.org/>
Feature Data Objects