Removing the 5000+ restriction on views

[D365Ideas_Admin]

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.

[D365Ideas_Admin]

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

Sincerely,

Narinder Singh

PM, Microsoft

[D365Ideas_Admin]

You can do that: http://support.microsoft.com/kb/911510

[D365Ideas_Admin]

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.

[D365Ideas_Admin]

Sharepoint can throttle views - go have a look how they do it

[D365Ideas_Admin]

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.

[D365Ideas_Admin]

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.

[D365Ideas_Admin]

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.

[D365Ideas_Admin]

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

[D365Ideas_Admin]

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.

[D365Ideas_Admin]

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.