Critical change to In Form Reports to enhance saving speed and performance, and to significantly reduce load on the server: Set In Form Reports to Default Show in Tables = False
Most users may not be aware that when an inform report is used in an Event Form, the system has to load ALL of the history for the In Form report Event Form, and then apply filters to it to display the data accordingly. This means if there are thousands of records for the Inform Report Form, these are taking a while to load. More critically, when saving events to display in the athlete history or reports page, the system again has to load all of the data in the background for EACH inform report form, which occurs regardless of whether or not the inform report was set to appear by default in the history or not! Thus, in some instance, thousands of records where having to be processed just for the in form report form (let alone the data for the form that was being saved) and this was contributing to poor loading speeds.
Additionally, if an inform report was included in a form that pushed data to an excel report or a live report, ALL of the inform report data was pushed to these reports load alongside the current query that was being run. Hence, a significant amount of load was being placed on the system, especially for forms that had a lot of data themselves, and then the inform report queries added more load. To combat this, we have two critical changes:
- We have changed the system so that any In Form reports set to "Default show in Tables" = No, will NOT load in the background in the athlete history or reports page.
- We have changed the system so that any In Form reports set to "Default show in Tables" = No, will NOT be sent to Excel or Live reports.
Please go through and turn off default shown in tables on all of the In Form reports that do not need to appear in the athlete history or reports page (remember that this stops data being pushed to Excel and Live reports as well). This WILL have a critical impact on speed; namely, turning these off reduced the saving and loading for an event form entered for only 11 athletes in group entry mode from 45 seconds to 9 seconds. See below for more details:
In Form Reports display data from a different form (as shown here).
Note that changing the In Form Report Advanced Setting to "Default show in Tables" = False will NOT stop the inform report from showing in the form when open. The In Form Reports in the image in the example are all set False, but they all show in the Event Form (on the main app and on mobile as well).
If you do NOT need to see the In Form Report history in the Athlete History or the Reports Page, PLEASE set Default Show in Tables = False
This means that these inform reports will NOT appear in the athlete history or the reports pages (as shown here)
In the example here, when In Form Reports are enabled to show in the athlete history and reports tables, it took 45 seconds to saving and display a single group entry for only 11 athletes (one athlete had 4000 records for the event pulled into the In form report, and these had to load in the system)
Excel Reports: when default show in tables = False, the In Form report data is not sent to the report, which significantly reduces load on the server
Each time an Excel Report is generated, ALL of the data for EACH of the inform reports needs to load and be sent with the Event Form Data to the Excel Report. When Default show in table =False, this means that the system won't send the data for the inform report to the excel reports, which significantly decreases the load on the system. Because some Excel reports link to cell references and not columns identifiers, we left the In Form report column name in the output, but no data is loaded into that system.
Live Reports: when Default Show in Tables = False, the In Form report data is not sent to the report, which significantly reduces load on the server
Each time a Live Report is generated, all of the data for each of the inform reports needs to load and be sent with the Event Form Data to the Live Report. Hence we recently had an example where there were ten In Form Reports used in a form that pushed out to a Live Report. When 10 users loaded the same Live report, this crashed the system; as it had to load all history for ten In Form Report forms (which had a significant amount of data), for all of the athletes, for the 10 different users at the same time. But, now when Default show in Table =False, this means that the system won't send all of the history for the In Form reports to the Live Reports, which will significantly decrease the load on the system. Because some Live Reports link to cell references and not columns identifiers, we left the In Form report column name in the output, but no data is loaded into that system.