PI SQL Commander performance issue.

Discussion created by gajendra_konnur on Jul 5, 2012
Latest reply on Jul 17, 2012 by gajendra_konnur

Hi All,


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?








Gajendra Konnur