Problem Note 65183: You encounter slow performance when you use the PIAF LIBNAME engine
 |  |  |  |  |
The PIAF LIBNAME engine was designed to retrieve all elements after making the connection and to treat "element" names as SAS member names (such as x.<element-name>). However, this process takes a long time to complete and affects performance if your site has hundreds of thousand of elements or more.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After you apply this hot fix, the PIAF LIBNAME engine does not retrieve any elements after making the connection. SAS does not treat elements as SAS member names. Instead, only virtual tables that are designed by SAS are read as the library members.
For compatibility, you can set SAS_PIAF_ALLOW_ELEMENTS_AS_TABLES=YES if you have not defined a large number of elements and want to use the original behavior.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to the PI System | Microsoft® Windows® for x64 | 9.43 | 9.43 | 9.4 TS1M5 | 9.4 TS1M5 |
| 64-bit Enabled AIX | 9.43 | 9.43 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| 64-bit Enabled Solaris | 9.43 | 9.43 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| HP-UX IPF | 9.43 | 9.43 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Linux for x64 | 9.43 | 9.43 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Solaris for x64 | 9.43 | 9.43 | 9.4 TS1M5 | 9.4 TS1M5 | ||
A fix for this issue for SAS/ACCESS Interface to the PI System 9.44 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F8X.html#65183A fix for this issue for SAS/ACCESS Interface to the PI System 9.43 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D3W.html#65183| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-12-04 14:40:15 |
| Date Created: | 2019-11-28 11:09:56 |