I have configured one template having few attributes in PI AF .Some of the attributes are having ref to PI points while others have sql table.
I have created around 50,000 elements based on this template :
I have then converted this template into TransposeArchieve and TransposeSnapshot Table using PI Sql commander. But its taking around 6-8 min to load data for TransposeSnapshot table as shown .While it was unable to load transpose archive table even after 20 min to ,so finally I canceled the execution of query.
Anybody have idea about the reason behind the problem and to improve the performance of the same?