Jump to content

SQL query

Anthony Vandercame

Recommended Posts


I would like to import my data from OSIpi but I can't use the package OSIsoft created by the communauty. So I would connect my OSIpi server to Spotfire by ODBC or OLE DB. It's work fine I can import my data. But my ask is if my OSIpi server contains over 1 billions of data and arround 5000 tags, when I create my request to import data (with SQL query), the OSIpi server can crash or become unavailable because the request is big My second ask is how to work SQL query If the server can crash, can I import data X lines per X lines If the data take many hours to be import is not a problem but the OSIpi server must not be crash!




Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...