Testing a Query
It is a good idea to regularly test your Query whilst you are building it to catch any mistakes early on. The testing tab will display the execution time, along with a list of the overall results.
To test a Query, click on "Test" on the right hand side of the Find Block tabs or on "Test" in the ribbon. In MooD Architect, the test tab has been altered to include a Count button. Clicking on this button returns the number of results the Query generates.
Optimizing a Query
Business Architect has query optimization built in.
You can see if your query has been optimized by the lightning bolts. If these don’t appear on one of the blocks, it means that MooD hasn’t been able to optimize that part. This may not be the best way to structure your query.
There is a lot of flexibility for more complex queries. More complex queries may result in lower performance.
Please refer to the appropriate 'Getting Started' guide for further information on query optimisation.
Please sign in to leave a comment.