I haven't seen a maximum for datagrids. They are actually the best performers for large datasets, in comparison with templategrids and listviews.
The pagination is only effectively used when using DB or XPath as source. Based on the config of number of rows only those rows are retrieved. Beware of using microflows/nanoflows as datasource as they will send all objects to the client.