Improving maestro* Performance Using Various SQL Grid Optimizations

Objective

This document aims atproviding solutions to improve the performance of maestro* (versions 3.05 SQL and 6) using SQL queries. Indeed, the use of various SQL optimizations in different strategic options of maestro* can make a real difference as far as performance is concerned.

 

Summary

• Switching to SQL Grids
• Activating the Quick Access Grids
  • Project Inquiry
  • Supplier Inquiry
  • Customer Inquiry
• Switching Read Mode to SQL
• Other SQL Optimizations

 

Steps

Switching to SQL Grids

In all screens displaying a transaction grid (as in the screenshot below, taken from the Project Purchase option), you can switch the grids to SQL mode instead of the classic mode. It is possible to switch to SQL mode mainly in the summary grids of transaction screens and it isalso possibled in search grids.

1. Right-click in the grid (transaction grid or search grid).
2. Select the Use SQL Query option.

 

Activating the Quick Access Grids

Project Inquiry

maestro* > Projects > Analysis and Inquiry > Projects > Project Inquiry

1. In the Project Inquiry window, click the Configuration icon.
2. Display the Other tab of the Project Management Configuration window.
3. Locate the Grid Selection (Transactions) section.
4. Check the Quick Access Grid box.
5. Close the configuration window to save your choices.

 

Supplier Inquiry

maestro* > Purchasing > Analysis and Inquiry > Suppliers > Supplier Inquiry

1. In the Supplier Inquiry window, click the Configuration icon.
2. Locate the Grid Selection section.
3. Check the Quick Access Grid box.
4. Click Ok to close the window and save your choices.

 

Customer Inquiry

maestro* > Invoicing > Analysis and Inquiry > Customers > Customer Inquiry

1. In the Customer Inquiry window, click the Configuration icon.
2. Locate the Grid Selection section.
3. Check the Quick Access Grid box.
4. Click Ok to close the window and save your choices.

 

Switching Read Mode to SQL

maestro* > Projects > Project Costing > Reports > Miscellaneous Reports

1. In the Miscellaneous Reports window, locate the Read data mode field.
2. Select SQL read mode instead of Classic mode.

 

Other SQL Optimizations

All previous configurations only applied to the current user. The following configuration applies to all maestro* users.

1. In maestro*'s main window, click the Help icon, represented by a question mark.
2. Select the About option.
3. Click the Properties link, in the bottom left-hand corner of the window.
4. Click the Advanced Configuration button.
5. Activate the various options in the SQL Optimization section, as required.

	SQL Optimizations
Balance Recalculation / Open Fiscal Year	Definition of financial periods for reporting. Benefit: Faster setup of accounting periods. Risk: Issues if the previous year is not closed.
Dispatch	Assignment of resources to projects and service calls. Benefit: Improved organization and real-time updates. Risk: Errors due to misconfigured rules.
Payroll Calculation	Processing of Canadian payroll entries. Benefit: Faster and structured payroll processing. Risk: Data errors or system overload.
Quotation	Creation of quotations and generation of work orders. Benefit: Streamlined workflow and cost tracking. Risk: Missing variables affecting accuracy.
Purchase Order Invoicing	Confirmation of invoice receipts linked to purchase orders. Benefit:Faster and organized invoice processing. Risk: Incomplete or mismatched data.

6. Click Ok to close the Advanced Configuration.
7. Click the Save icon.

 

See Also

• Accelerate your grid searches with dynamic filters
• Reduce the display time of a grid by desactivating it

 

Last modification: September 02, 2025