Kes,
That depends. A reader will keep a connection to the database open while
you're looping through the records. If you have a delay built into the
loop that connection may be open a long time.
I would probably put the records directly into a datatable (you shouldn't
need the overhead of a dataset) then the connection will close right away
while your loop runs.
If this is being triggered from a website and is going to take a while to
run you will probably run into timeout issues. You may want to think about
starting up a new thread to run this send routine and then poll that
thread to see when it finishes.
Here's an article on multi-threading in web apps that I think will help
you:
http://www.ftponline.com/vsm/2002_11/magazine/features/chester/
--
Sincerely,
S. Justin Gengo, MCP
Web Developer / Programmer
www.aboutfortunate.com
"Out of chaos comes order."
Nietzsche