This can be a performance problem with any dataset and it’s a major problem with large datasets.
Whether sorting, grouping or filtering, it will optimize queries to quickly pull only the necessary data.
It also does intelligent caching so it doesn’t have to run the same query if it was recently run.
NET scalability is loading large datasets in a paged grid.
What typically happens when displaying large datasets in a grid is that all the data is fetched instead of just the data needed for the current grid size and settings.
To access the new values you need to handle a different event; namely the Row Updating.