bergeron_iti

What is the fastest way to write/delete value in archive?

Discussion created by bergeron_iti on Feb 2, 2012
Latest reply on Feb 5, 2012 by bergeron_iti

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?

Outcomes