800xA Report Performance with the Report Action plug-in
In a report Excel template exists around 250 signals from ABBGetOPCDA("[Control Structure]..). the duration to generate report takes around 30 seconds.
- What does it need so much time? To read the opc items?
- How can I imporve the performance?
- Is it possible to show the state of the running report Job on a graphic Display (To inform the user)?
- Does exist other report solutions (faster) for the 800xa?
Voted best answer
250 signals in one report page is too much.. ABB standard templates are designed to hold 8-10 signal. Of course for 250 signals, it will take time..
As far as I know, retrival from data base will not take time. It is creation of excel report and writing it in a location will consume time..
250signals are pretty more for an excel addon like datadirect. So approximately 30seconds is acceptable time.
As an alternative way, you can use snapshot report software for reporting. Please see below link for details:
To inform user, you can use "System Messages" side of Action Aspect. You can both choose "Log Action Start", "Log Action Done" or "Log Action Both Start and Done". Please see below picture for more details:
Operator or user can see Action State from, System Event List menu.
Hope these help you.
One important point is to save the excel worksheet with calculation mode "Manual". With this option the calculation execute only once.
Now my report (250 signals with the ABBGetOPCDA Macro) takes around 15seconds (10secondes for calculate, rest for excel Opening and export).
To check the around time for the calculation, the answer from stefan stromqvist is a good simple proposal.