I have a client that is using Transaction Groups as their historian. One of there tables has 47 columns and is inserting new rows at a 5 second interval.
When using the DB Pens with the Easy Chart it tries to pull all data points within the selected timeframe. Is there a way to set a resolution or grab every nth row? I know it can be done with the Basic Chart since you load the data directly and a properly structured query would accomplish it. The Easy Chart historical settings allow you to determine data resolution or density but nothing for DB Pens?
For example if a user selects 5 days worth of data then the Easy Chart is trying to handle 4 million data points (47 pens at a 5 second interval over 5 days). But there is no way to tell the Easy Chart to only return 1000 data points spaced evenly apart.
Any ideas or thoughts will be appreciated! Thanks!