On a medium powered OLTP database server, I would consider 100,000 rows or less to be a small amount of data. However, to understand the potential for blocking and duration of the process, tell us how many concurrent users, the type usage, and also describe the ETL step that loads the destination database: bulk insert, batch insert, merge, slowly changing dimention, etc. ?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho