Hello
We are using Business Contact Manager 2007 on a SQL Server 2005 and have some performance problems with it.
I have noticed, that it executes thousands and thousands of the same or similar queries. One of them is the following. It performs queries like that about 10 times a second and sometimes from multiple users.
Can anybody tell me where this query comes from and what it does?
BeginReadTransaction; select top 100 percent Field12296, Field3591, Field4089, EntityTypeCode, ActivityType, ViewRowID, IsCAO From (Select Field12296, Field3591, Field4089, EntityTypeCode, ActivityType, ViewRowID, IsCAO from OpportunityIMAPIViewForActivity v where IsDeletedLocally = 0 AND ((((IsCAO = 0) AND (ViewRowID in (160911,38964,10822,142665,11007,160087,109983,93034,66111,22157))))) UNION ALL Select Field12296, Field3591, Field4089, EntityTypeCode, ActivityType, ViewRowID, IsCAO from ProjectIMAPIViewForActivity v where IsDeletedLocally = 0 AND ((((IsCAO = 0) AND (ViewRowID in (160911,38964,10822,142665,11007,160087,109983,93034,66111,22157))))) UNION ALL Select Field12296, Field3591, Field4089, EntityTypeCode, ActivityType, ViewRowID, IsCAO from ActivityIMAPIView v where IsDeletedLocally = 0 AND ((((IsCAO = 0) AND (ViewRowID in (160911,38964,10822,142665,11007,160087,109983,93034,66111,22157)))))) as bs
Bookmarks