Designing Queries

When executing queries against external databases, if a query performs badly, it is quite easy to assume the database is the culprit and Dekho is the victim.  However, it could be that the Dekho query is the culprit.

Designing efficient queries is important to avoid both wait times for Dekho Users and putting excessing load on the database.

Make use of Map Service Sourced Queries

Only Select the Fields Needed

Avoid Queries That Return Large Resultsets

Make use of Database Indexes

Make use of Database Views

Indexing with oneSearch