Is there a maximum number of records you can transact on before the system times out on you?

There shouldn't be. We have seen transactors select 500 rows at a time, without issue.