Does anyone know what is purpose for this table sqlth_sce.
There are over 90,000 records in my table.
And for some scid, it's over 40,000 lines.
When I check my database log, it keep updating this table and give performance issue.
Huge data in sqlth_sce, Stale Data Detection how to prune records after turn of Stale Data Detection
sqlth_sce This table stores start and end times for tag groups.
See Ignition Database Table Reference | Ignition User Manual.
The problems I am facing with is there are lots of deadlocks and slowness of my system, so I am trying to find the reason, so I look at this table sqlth_sce .
I find below document , this may relate with my deadlock issue. I turned off off Stale Data Detection following below instructions.
But there are still 94285 records of this table , sqlth_sce ,
how to prune those records.
Can I just delete it, what would be the impact.
Ignition Historian Guide | Ignition User Manual (inductiveautomation.com)
You would likely lose some of your history. The extra records likely need to be conditionally pruned. Consider asking support to look at your situation. IIRC, there was a bug recently fixed that would produce extra records in sqlth_sce. You might be affected.
May I ask which vision this bug is fixed in ?
I don't see anything in the change logs for this, but there are quite a few posts on this topic in the forum. Perhaps one of them will be helpful to you:
Forum Search: sqlth_sce
1 Like
For whom might meet with same issue.
There is no dead lock after I turn off Stale Data Detection and delete data in sqlth_sce .