I have 730 Pi Tags which contains data from 2013, average timestamp every 10 minutes.
I tried to delete all data from PI Archive using DELETE statement in PI SQL Commander.
WHERE tag LIKE '1WPPW%' /* all tags I want to erase begin the same 1WPPW... */
Execution lasts extremely long and what is interesting only the last values are deleted ( I mean every tag loses only the latest value ).
I tried to narrow the timerange:
WHERE tag LIKE '1WPPW%'
AND time BETWEEN '2017-01-01' AND '2017-02-01'
Result is the same.
Thanks in advance, Peter.