We have purchased some touch panel and make it to “best performance”.
As ignition edge doesn’t have db capacity, we only can connect to default Edge historian.
I have created one screen for power chart and one screen for table to populate the historical data. The response is very slow.
How can we improve it?
What hardware specifications are you running it on?
In addition to what @David_Stone asked, how much data are you retrieving? Both in terms of length of time and number of tags in the query/trend.
for the Data Table. I have retrieved 27 column,1min periodic query for 7 days.
for the Trend, above 50 tag to be log into Edge Historian. but in default, 13 tags and 1 hour has been populate when navigate to the trend view.
my Touch Panel hardware specification as below:
Processor: Intel Celeron CPU N3060 1.60GHz
RAM: 8GB
The entire ignition client is not very smooth. any advise for this hardware spec?
Are you running windows? If so, first way to optimise this is to use something other than windows that doesn't kill the performance of your hardware.
This processor is not suitable for smooth trending, you will display things OK on the screen, but because browsers only render in single threaded configuration, the processor on this will never be good enough for snappy smooth rendering.
To give you perspective, rendering trends on a raspberry pi 4 is similar to this, and its not brilliant, the upside is it doesn't use windows, so it is better at using all available hardware resources.
Raspberry pi 5 is fast enough to run things much more acceptably.
Make sure you're only retrieving what you need and nothing more (Do you really need all 7 days displayed?). The current query is retrieving 10,442 rows. Since you're using Min/Max, you might also change that to something else as I believe for reporting in a table it will return 2 records for every minute - doubling your data due to one record for min and another for max.
So can i say upgrade the CPU will be the ideal solution? I can run smooth using my own laptop. But when things come to Touch Panel. it is bad not only the trend/data table but also for entire application.
Actually customer need longer period, I have convinced them to 7 days. They need to export the data to csv for further analysis.
Any advise for the default aggregation mode? i dont want 2 record in a single minute.
Something like this:
If that's the data you're getting, then it's fine. You probably need a higher powered computer to run this on to pull that much data and export to CSV or excel though.
Do we have any documentation regarding hardware recommendation in ignition website? Now my entire ignition application is not smooth enough.(not only trend/data table view)
Have you looked at your CPU and memory usage on that PC? As others have mentioned, Linux will use less resources for the OS, so can give better performance as well. Have you edited the ignition.conf file to increase the initial and maximum memory to give the application more memory to work with?
I just checked the performance on gateway. Our memory allocation is 2048, and the memory trend never hit 1000.
I believe that our processor is not good enough to run ignition. When we run ignition, the CPU alway shoot to 100%. It only back to normal (<40%) when we stop the ignition gateway and shoot up again when we start gateway.
Below is the panel datasheet we used for our project.
got5103w-845.pdf
I would still increase the memory allocation in the ignition.conf file, but that CPU is definitely underpowered. It only has 2 cores. You'll want a more modern processor that's both faster (avoid Celeron) and has more cores. Unfortunately that means buying an entirely new PC as you can't just upgrade the one you have.
While you could try the Pentium N3710 model, as you can see from the link, it's faster but still a 9 year old processor.
