Ignition v8.1.36
I have a report that takes several minutes to load for all days before a certain date. The report looks at historical data for 1 day at 15-minute intervals (so query should return 96 data points per day). The report gathers the data through a script that uses the system.tag.queryTagHistory() function. The start and end dates for the query are set to be beginning and end of the day, so the range for this query is limited. For this project, I needed to import the relevant historical data ranging from 2021-2024 into the Historian and all of the importing was completed on April 27th, 2026. When I select a date after April 27th, the report loads quickly, but selecting the 27th or any day before causes the report to take several minutes to load. On the Historian database, I looked at the 'sqlth_te' table and searched for the relevant tag paths and saw that about half of the retired entries for the tags had roughly the same 'retired' date of April 27th, 2026, which I believe to be the root of this issue. The 'created' times correlate with the time stamps for the imported history of those tags. I confirmed that none of the ids for the retired entries exist in the partition for April (sqlt_data_1_2026_04), and I already reindexed the 'sqlth_te' table for the Historian through SSMS, but it only marginally improved the report loading times. Are there any other actions I can take to improve the loading speed of the report?