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.