AF Tables Max size

I have a very large table that I need to include in our PI System. It has 5 columns and more than 100,000 rows. The idea is to use it as a lookup table for expected generation values, based on hour, irradiance, and month, for each of our parks.

What is the best way to integrate this table into the PI System?

Does anyone see an alternative solution to address this need?

Parents

0 Alassane Seck 4 months ago

Hello,
I understand that your intent is to link the table, not import it correct? If so, your best option in my experience is to use parameters for your linked table , as hinted by gmerciel .(See : Parameters for linked table queries)
This will limit the amount of data retrieved from the external database to just what is needed on a per element/attribute basis. Suggest you give it a try and let us know how it goes
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Alassane Seck 4 months ago

Hello,
I understand that your intent is to link the table, not import it correct? If so, your best option in my experience is to use parameters for your linked table , as hinted by gmerciel .(See : Parameters for linked table queries)
This will limit the amount of data retrieved from the external database to just what is needed on a per element/attribute basis. Suggest you give it a try and let us know how it goes
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data