1 Reply Latest reply on Nov 19, 2013 2:44 PM by Karlo.Zatylny

    Dependencies Slow...slow...slow...is there a fix

    bsciencefiction.tv

      I have long noticed the Dependencies applet is always very slow to load.  Actually, I usually abandon a page before it ever loads.

       

      So we set up appsight on our SQL database.  What did I find?  The query for dependencies is by a mile our most expensive query.  Clocking in at almost 3 minutes.  Is there a fix for this or is it a poorly written query...because it does not take but a second to run my query in SQL manager?

        • Re: Dependencies Slow...slow...slow...is there a fix
          Karlo.Zatylny

          Hi,

          This is a known issue in some environments.  While a simple "SELECT * From [dbo].[Dependencies]" will execute quickly in SQL Manager, the page will not load quickly because of the JOINs necessary to get all the data for the page to display.  A dependency parent may be a Node, Group, or Interface, and a child may be a Node or a Group.  Hence, we join these tables to the Dependencies table in order to get the Name and Status of these dependency relationships.

           

          Performance will be slower when you have more Groups, and in particular more Groups that have Dynamic Queries associated with them.

           

          Your environment sounds too slow for usability though, so I suggest opening a support ticket so that support and development can take a first hand look and make improvements to this page in a future release.

           

          Thanks

          Karlo