How to remove the 100k records limit?

Q:

How to remove the 100k records limit to display in the Data View?

A:

We have forced the limit of records displayed at a time to avoid Out of memory errors. 100k is the number of records which seems to be impossible to observe one by one by a human at the acceptable time. For other types of actions with the data you can use other means: data export, totals calculation, filters, query parameters etc. All of these operations will be performed on the full amount of data returned by the query or records existing in a table. This limit is only for displaying data in the grid.