Myself and my team has been trying to find a solution to reduce the query time to obtain data from thousand of tags. We are using an AWS SQL database and have experimented using the python console to query.
Our main query function is based on “dataset = system.tag.queryTagHistory(paths=paths_to_read, startDate=startTime, endDate=endTime, returnSize=1, aggregationMode=“Average”)”
Our total time of query takes around 20 seconds.
Is there suggestions on how we should approach the query to reduce the polling time ?
Would it have any effect if we upgrade either our SQL server, or our Ignition server hosting machines?