orgrez710

PI OLEDB Provider inserting multiple rows in one server call

Discussion created by orgrez710 on May 7, 2014
Latest reply on Mar 13, 2019 by Jairsinho

Hi, I've been developing PI server client using OLEDB Provider. I need to insert multiple rows into picomp2 table into multiple PI Points. I'm trying to do something like this:

 

INSERT INTO piarchive..picomp2 (tag, value) VALUES ('MyTag1', 10.2), ('MyTag2', 8.5), ('MyTag3', 10.5)

 

but it seems it is not working. The thing is that I need to insert thousands of records in the shortest time possible (a second). Inserting single values one by one takes unacceptable time.

 

Is here in fact any way to do this using OLEDB Provider or maybe should I use PI SDK directly in my application?

 

Thanks a lot.

Outcomes