Problems with a Slow Query

Problem: A query (an object query, or a findWithQuery or executeQuery) is slow.

Explanation: Some attributes of the MBO used in the query's where clause or join conditions are not indexed.

Solution: Try to add necessary indexes for those attributes used in where clause or join conditions.

You can only add indexes when defining object queries. To add indexes by defining object queries, in Unwired WorkSpace - Mobile Business Object Development see Creating Object Query Indexes.