I'm looking back at history data tables and I noticed that some older tables (e.g. from before Nov 2023) were querying in 50s instead of <1s, and found that there was no clustered index on the tagid and t_stamp fields like there are in later tables. I note this note in the user manual, but there's n…

IIRC, indexes were not always included. I remember seeing somewhere on the forums where it was suggested that the end user needed to add indexes to improve performance.

[image] lrose: suggested that the end user needed to add indexes to improve performance I don't know if I ever did this, but definitely the data tables for 2024 and 2025 all have them and I certainly haven't added them myself. That's why I presumed it was maybe changed in a version. It seems …

Well, here is a post where I was clearly positive that they were not there by default in 7.9. [image] Tag Historian/SQL Crashing The performance issues come in if no indexes have been added to the tables (they aren't there by default in 7.9) and so the database engine will have to trudge through…

Were indexes always included in sqlt_data_* tables?

Ignition

lrose July 28, 2025, 4:42am 4

Well, here is a post where I was clearly positive that they were not there by default in 7.9.