Client Management Suite

 View Only

  • 1.  RMV_AddRemove View in %whateverwecallitnow% 7

    Posted Jan 25, 2011 01:16 PM

    When I run

    select *
    from RMV_Addremove

    it takes over 30 seconds to complete. This strikes me as a long time and I was wondering if anyone knew anything about this?

    Running SQL 2008, off box, 24 GB RAM, SAN attached.  I think it is a problem with the view not the DB server.



  • 2.  RE: RMV_AddRemove View in %whateverwecallitnow% 7

    Posted Jan 25, 2011 03:00 PM

    Do you actually need all the data from the RMV_AddRemove view, or would enough data exist in the Inv_AddRemoveProgram table?  The RMV_AddRemove view uses quite a few joins and is therefore more intensive.



  • 3.  RE: RMV_AddRemove View in %whateverwecallitnow% 7

    Posted Jan 31, 2011 08:45 AM

    I need the install path which is not included in the table.  I had our SQL guy look at it and he pulled out some extraneous joins which brought the run time down to a little over 1 second from 30 seconds.  For now We will probably just go with this.  I could open a case with support but I am going to wait for 7.1 to come out to see if the fix the view.  If not I will open a case to get it addressed.