Suggested Tue, 23 Aug 2011 13:00:00 GMT by ERIK AARSLEW-JENSENPlanned
Category: Data Management

I know that there is a way to remove the 5000+ restriction on views, through an unsupported modification of the DeploymentProperties table, and you probably have some reasons a to why it was introduced, but from the clients point of view, it makes no sense.

In MS CRM 4.0 clients we're complaining of the lack of a counters on view, they got it, but now they are basically all complaining about the 5000+ counter.

It should be possible to achieve a decent performance on even large tables, if not, you could consider employing a two-phase counting scheme, first rendering the 5000+ count one the view to increase response times and then update the actual count through ajax or something similar, asynchronously.

Status Details

Thank you for your feedback. We are re-categorizing this feedback to get it in front of the right team.



Narinder Singh

PM, Microsoft

Comments (10)
  • 7 years and still waiting... Go Microsoft! ;)
  • Agree, really annoying having to export all the records just to get a figure.  Hopefully MS can come up with a way that doesn't compromise performance.

  • We really need this to be able to quickly look into the total count. Exporting the data is more and more being restricted due to privacy regulations and this way analists can still produce the correct numbers without extracting the data.

  • Is this still being looked into? We recently upgraded from CRM2011 (which has a counter) to Dynamics 365 (which only displaces 5000+).

  • Thank you for your suggestion. We are considering this functionality for a future release of CRM.

    Mike Carter

    This posting is provided "as is" with no warranties, and confers no rights.
  • Agree.

    Ppl may notice about KB: http://support.microsoft.com/kb/911510
    Perhaps, it is no longer works after UR10 - you will get erro "Invalid Argument" though.
  • It's not possible to explain the sense to the customer - he knows the SQL statement "select count(*) ...".
    Additional, in CRM online it's not possible to move the value, because you don't have access to the SQL server.
  • Sharepoint can throttle views - go have a look how they do it
  • I'm not taking about removing fetch xml throttling, which makes a lot of sense. I'm looking for a more "native" support for count, utilizing the power of the sql database, which doesn't retrieve all records from the database in order to count them.
  • You can do that: