Displaying of more than 5000 records

Hi can we display more than 5000 records on a web page using this and if we can do how much time it will take to reload the page if any operation is done on any of these record

AW version 2 has something called Virtual Rendering.

If Virtual Rendering is turned on (it is by default), then displaying 5000 rows is not a problem. The ones which need to be displayed onscreen will be rendered, while the rest of the data is left unrendered. This does mean however, that when scrolling the data up and down, the user may experience a short (fraction of a second) delay while the data is rendered.

In small grids (less than a few hundred rows), one can turn virtual rendering off to improve the scrolling speed, but this will slow down the initial loading of the page.

Are all the records stored in memory of the local machine? Or can the grid perform equally on 5000 records as 1 million records by doing appropriated database queries as needed?