I have an issue with a huge database of tag historian with Millions of registers. I am trying to find the the root cause of this huge tables . I suspect some History scanclass can has any bad setup.
In this case i am working directly with mysql . However i just only get time out in my queries.
For example i try:
select tagid,count(tagid) from sqlt_data_1_20190227 group by tagid
Thanks in advance,