Solved: ADO Recordset Limit

[Marcster]

Hi people,

Does anyone know if there's a limit on the number of records that an ADO recordset can have/fetch?. The actual 'ADO select from' recordset.

Thanks,

[stanl]

Hi people,

Does anyone know if there's a limit on the number of records that an ADO recordset can have/fetch?. The actual 'ADO select from' recordset.

Thanks,

should be no limit, but there are several dependencies

connectiontimeout
commandtimeout
cursorlocation
cursortype, i.e. static vs. dynamic
cachesize

which affect performance/speed and ultimately success/failure of a query. Stan

[Marcster]

Cheers Stan,

for ref the connectiontimout default is 15
the commandtimout default is 30
there's also the MaxRecords property that can be set to retrieve a set limit of records.

Marcster