6 Replies Latest reply on Aug 31, 2018 2:28 PM by sraposo

    PI AF ELEMENT LIMIT

    sue_clark

      Hello - is there a maximum number of elements allowed in PI AF? Or a limit per hierarchy?

        • Re: PI AF ELEMENT LIMIT
          Lal_Babu_Shaik

          Hi Sue

           

          As far as I'm aware there is nohard limit on number of elements that can be created in a single hierarchy. For better performance we generally restrict between 6-10 levels and based on business functionality. But interms of performance i will always recommend to restrict number of level as much as possible without impacting business view.

           

          Performance aspect :

          AFElement.FindElementsByPath Method (IEnumerable(String), AFObject)

          The performance of finding elements by path can vary depending on the syntax, server version, path length and hierarchy depth. For best performance, make sure you are using the latest AF Server. Simple relative paths (no substitution or navigation up or across the hierarchy) will perform better. Element paths which exceed a length of 420 characters or a depth of 24 levels will execute slower.

           

          Thank you,

          Lal

          4 of 4 people found this helpful
          • Re: PI AF ELEMENT LIMIT
            emendelsohn

            Hi Sue,

             

            I'll also add to Lal's response that while there may not be any known software limitations for max number of AF elements, hardware must be appropriately sized for the SQL server. As Lal mentions, hierarchy can also have a big impact - for example, if you have a flat hierarchy with a large number of elements at root level it also may not run as well as having something more broken up and you may see performance issues within PI System Explorer - so this should be kept in mind when considering 'limit per hierarchy'.

             

            Best,

            Emily

            1 of 1 people found this helpful
            • Re: PI AF ELEMENT LIMIT
              sraposo

              Hi Sue,

               

              How many elements were you thinking and how will the data be consumed by clients?

               

              And to add to Emily and Lal, please refer to for proper system sizing: https://techsupport.osisoft.com/Downloads/File/8d7f6f38-2ed3-43f3-a7f5-a15789e6bca7?_ga=2.250644160.776872591.1535376635…

               

              Thanks,

              Seb

              2 of 2 people found this helpful