The default is not changeable.
It defaults to 1 to ensure that overlarge data sets are not created that could overload the servers memory and other resources.
The thinking is that if you are not using a repeat region to return more rows, then really you will most likely only use the first record in the result.
In the recordset you can set the limit to 0 if you don't want to add a repeat.