Grafana is the preferred display for management. Are there any recommendations for best practices or Design paradigms to follow? We created a webdev endpoint in 8.1.x to provide historical data to Grafana, and this has been working fine for the last few years. There have been some questions regarding our direction (performance wise), so I am looking for guidance from the forum. Where are the bottlenecks? Queries per second? bytes requested per second? for network throughout? Is this basically what can the server handle? The Grafana displays ~3k were developed with a different historian /platform and we would like to move all these to Ignition one day. Note I am a Perspective fan, please don't respond that the best design paradigm is to move to perspective.
In the past, I connected Grafana directly to the SQL Historian DB, and issue the same queries that Ignition was using to return data (there are a series of queries that Ignition issues to a database, in succession, in order to return the data from the appropriate tag ids within the various data tables).
I can't recall specifics - but believe I created a view which made the (parameterized) query 'easy' from clients which connected to the Historian DB directly.
This approach should increase your performance significantly - at the expense of potential ongoing maintenance of your queries (schema might change between Ignition versions, database technologies, etc.).
Thank you for sharing this. It certainly is an avenue to explore.