Make use of Map Service Sourced Queries

Map Service sourced queries are constrained to only pull attribute data from the map services within the Dekho Maps.  Compared to JDBC sourced queries, they also lack the ability to alias fields within the SQL or pull in additional tables from non-spatial tables.

If a query requirements are not affected by these constraints, it is recommended to use map service sourced queries over JDBC.  Map service sourced queries have quicker response times than JDBC sourced queries.



A JDBC query will first need to find the associated record(s) from the database, and then do a 2nd trip to the map service to pull in the corresponding feature from the geodatabase layer.  With a Map Service query, both the attributes and feature are returned in one trip from the geodatabase layer.



Only Select the Fields Needed