|
|
Rank: Member
Groups: Member
Joined: 8/4/2010
Posts: 10
Location: paris
|
Hello
I'm writing a program to insert a large number of data in the database of PI in a minimum time. I insert data from 10 different points. What is the most powerful system for this type of operation: Oledb, Odbc, Sdk, Api? I insert in multithread.
My program is currently in C #, should I switch to C + +?
Thank you
|
|
|
|
|
OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System. We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ or contact OSIsoft vCampus for more details.
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 617
Location: Cheshire, United Kingdom.
|
Hello, Welcome to the forum. PI-OLEDB calls will be translated to PISDK calls, so unless you have the explicit need for OLEDB (e.g. SQL Server Linked Server) I would stick to PISDK. PI-API is usually not used and PISDK recommended instead. Short answer, you should be fine to use C# with PISDK (providing you have the relevant development licences). There are examples on here and over on vCampus if you need any specific help. Principal Consultant
Real-Time Data Management @ Wipro Technologies
|
|
|
Rank: Member
Groups: Member
Joined: 8/4/2010
Posts: 10
Location: paris
|
Thank you very much.
To execute sql queries, is it more interesting to use ODBC or OLEDB?
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 617
Location: Cheshire, United Kingdom.
|
Personally, I would say OLEDB. Principal Consultant
Real-Time Data Management @ Wipro Technologies
|
|
|
Rank: Member
Groups: Member
Joined: 8/4/2010
Posts: 10
Location: paris
|
Thank you,
I tried the API and I could not insert with a time taking into account the milliseconds. Is it possible to insert with a time taking into account the millisecond?
|
|
|
Rank: Member
Groups: Member
Joined: 8/4/2010
Posts: 10
Location: paris
|
The API seems to insert two times faster than the Sdk. Why is Api not used?
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 617
Location: Cheshire, United Kingdom.
|
The issue with PI-API is that in order to have a valid development licence for OSIsoft products you need to hold a vCampus membership. The vCampus licence doesn't provide development rights on PI-API (or support it) thus you would need to develop with PI-SDK (unless you have some special arrangement with OSIsoft). Then you can argue that API is sequential and SDK object-orientated, plus API doesn't implement some of the newer security features and new functionality. I know there are some performance improvements coming in next versions of PI-SDK to support better inserting of multiple values. That said, be sure to log a ticket with OSIsoft TechSupport for any performance issues, it will ensure they address it in future versions. Principal Consultant
Real-Time Data Management @ Wipro Technologies
|
|
|
Rank: Member
Groups: Member
Joined: 8/4/2010
Posts: 10
Location: paris
|
Thank you for helping me!
|
|
|
|
Guest
|
