When setting up a new database connection, one of the last options is for "max records returned". I'm a little confused by this and how what effect it would have if you have selected too few records.

The default is 1000 but let's say you use this database connection later on for a recordset that contains far more than 1000 records. If you choose too small a value for "max records returned" when you're first setting up your database connection, does it cause you problems later on when there are far more records than that?

What happens if you leave it empty?
Is there a performance issue if you set too high of a number for this value?

Hello Steve,
You can set this value some bigger number than 1000 if you need to. The field cannot be empty.

Is it possible to have it return all the records? Entering a value of 0 returns zero records. Or perhaps, is setting the value to some impossibly high number the best way to get it to return all the records?

Hi Jack,
Unfortunately 0 cannot be used as a value. Please use some really big number, that you are sure is bigger than the total records number