when sending rows, limit the queries to 10000 rows at once, to reduce slow query warnings and buffering