Calculation panel: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
Line 30: Line 30:


===Update Indicators and Reset Excell X-Queries===
===Update Indicators and Reset Excell X-Queries===
<gallery>
File:Update_Indicators_option1.jpg
File:ResetExcelXQueries1.jpg
</gallery>
Below an explanation of the difference between the two options:
Below an explanation of the difference between the two options:



Revision as of 14:43, 20 January 2021

Please note: This page is currently being updated.

Introducing the Calculation Panel

The Calculation Panel helps you to manage the calculation time of your project. The Calculation Panel can be found by hovering with your mouse over the Refresh button, under the File menu tab in the top left corner.

Recalculate panel2.jpg


The options in this panel will allow you to set up how indicators, panels and Overlays are being (re)calculated and provide an overview of the calculation time of some of the components in your project. For more guidelines on calculation performance see Troubleshooting calculation performance.

Auto-update indicators

This option is by default turned on and ensures that whenever you make a change in the Editor, the indicators, panels and Overlays will be recalculated immediately. When the auto-update is not checked, you will have to manually refresh the project after making an adjustment. You can refresh the project manually by choosing one of the available Reset options (see below) or by clicking on the Refresh button. Compare the three different states below.

Scheduled Update (long running)

When running long calculations, e.g. in a large project area with a grid overlay with a very small grid size, the calculation time allowed during office hours is capped at a maximum amount - one hour as of the time of writing. By selecting the option "Scheduled Update (long running)", your project is set to 'Keep Alive'. You can now exit the client and your calculation will take place after office hours, when there is no limitation on calculation time used on the server. This ensures that more complex calculations can take place in the background over night, whithout these long calculations hindering other users on the server during peak hours.

There is also an option upon completion of the calculation to be notified by text message (SMS) or email.

Update Indicators and Reset Excell X-Queries

Below an explanation of the difference between the two options:

Most of the time, in an Indicator Excelsheet X-Queries are used. If you have for example three areas in your project, an X-Query would be as follows:
SELECT....WHERE_AREA_IS_X
In the Tygron Platform this query is translated to the following three queries:
SELECT....WHERE_AREA_IS_0
SELECT....WHERE_AREA_IS_1
SELECT....WHERE_AREA_IS_2

When using Update Indicators, for example if you changed an attribute of one of these areas, the three queries are recalculated. If you choose Reset Excell X-Queries, the X-Query is again translated to queries. If you for example added a new area, in the Tygron Platform the X-Query is then translated to:
SELECT....WHERE_AREA_IS_0
SELECT....WHERE_AREA_IS_1
SELECT....WHERE_AREA_IS_2
SELECT....WHERE_AREA_IS_3

If you used Update Indicators in this case, the fourth area was not taken into account, since the three queries would be recalculated again and the Tygron Platform would not translate the X-Query to other queries.

When to choose which option?

Choose Reset Excell X-Queries if the amount of areas or neighborhoods is changed (for example by adding or removing an area/neighborhood). Choose Update Indicators if the amount of areas or neighborhoods stays the same (for example if you only changed an attribute of an area or if you did not use X-Queries in your Excelsheet.

Using any one of these option affects all indicators, panels and grid overlays.

Performance overview

The performance overview shows an overview of the components in a project and their calculation time. If your project performance is slow, check the overview to see which component(s) could cause this.

  • Performance overview panel
  • Uitleg Performance Overview Paneel (Dutch only)


GPU overview

The GPU cluster overview shows the different GPU clusters that are available for calculation and their status. If they are busy with calculating components of another project, it will be visible here. Also your own calculation jobs will be visible in the panel and the possibility to cancel your own calculation(s), by clicking on the cancel icon (see image).