What is the fastest way to write values in archive?

Discussion created by bergeron_iti on Feb 2, 2012
Latest reply on Feb 21, 2012 by andreas

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.


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?