Query limit in groovy

Summary:

Currently engaged in a customization project within Oracle Sales Cloud utilizing Groovy scripting. I am aware that the default limit for fetching records at one time is set at 500. However, I seek to gain a deeper understanding of any additional limitations that may pertain to fetch queries executed within Groovy scripts.

In particular, I would appreciate clarification on the following points:

1. What is the maximum number of records that can be retrieved in a single Groovy query?
2. Are there any best practices or recommendations for managing queries that might surpass this limit?
3. Are there any performance considerations or constraints that I should take into account when executing large fetch queries in Groovy?