If you remove the -r 1, but leave the -b 1, they will indeed be streamed in 1 at a time. If you only have a few rows, it will appear that they are all coming in at once, since ESP an handle multiple thousands of csv events per second. if you have only a small data set, experiment with -r N for various values of N. N is the target rate the adapter tries to maintain. For slow rates (< 1000) it is more approximate. If you have 1000 rows, and set -r 100, it should stream data for approximates 10 seconds.
Hope that helps,
Scott.
... View more