I'm trying to write a large amount of values in the archive. Basically I have to write 1 point for each 10 minutes for a specific day for 6 tags and about 350 equipments. If we add up every thing, it means about 864 points ( 6 x 144) per equipment times 350 so about 325 000 values. On top of that I will have to delete the existing values because they are not exactly at the same date and time.
So I wrote a procedure with sql server that use the PIconfig interface to write them, to do so, I create one file per equipment and I process them in a loop.
Then I have 2 issues:
When I try to write in the archive I receive an error that says that mode edit is not valid.
When I try to write in pisnap, it works but it takes about 1 minutes per equipment, which is really too long.
Someone has an idea?