Hi @test29998411 , welcome to Microsoft Q&A forum.
As per the article, "By default, results are returned in chunks of 100 items or 1 MB, whichever limit is hit first."
However as you rightly mentioned we can change this value based on our requirement by ingesting into 'MaxItemCount' property.
"You can specify the maximum number of items returned by a query by setting the MaxItemCount. The MaxItemCount is specified per request and tells the query engine will to return that number of items or fewer. You can set MaxItemCount to -1 if you don't want to place a limit on the number of results per query execution."
Please let me know if this helps or else we can discuss further.
----------
If answer helps, please select 'Accept Answer' as this could help other community members having similar issues.