IMPROVE PERFORMANCE FOR QUERY

Hi @Brad Nesom​,

Please try using a FeatureReader with the AOI as the input feature. Set the FeatureReader up to read the SDE, then set the Constraints - Spatial Filter to Initiator OGC - Contains Result. For many spatial databases, this will push the filtering onto the database application.

Thank you @daveatsafe​ ,

That for some strange reason didn't work the first time i tried it. i changed spatial filter and got results. then when i switched the filter back to OGC contains i did get results. (first results below. THANKS!)

The minimum (x,y) and maximum (x,y) bounds, respectively, of the search envelope being used are: (-103.32700721710732, 31.673369732325778) , (-103.13470161721034, 31.824363673050264)

Destination Feature Type Routing Correlator (RoutingFactory): Tested 0 input feature(s), wrote 0 output feature(s): 0 matched merge filters, 0 were routed to output, 0 could not be routed.

HOWEVER: If i use the same wb but put these coordinates into the sde reader as minxy, maxxy values i get different numbers of features than i get from the OGC contains. I have switched a couple of times to other filters but cannot match the numbers by manually putting the values into the reader.

Ideas?