Mutli Email

[WebBuilder451]

I'm writting a page to send multi emails (just a few at a time, max 100) once
a day.
should this be done using just a reader, or is there a way to do this with a
dataset?
thanks
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes

[Mr Newbie]

If all you are doing is reading from the database and not updting it then
the reader is the fastest (one way) and most simple data aquisistion.
HTH
"WebBuilder451" <We***********@discussions.microsoft.com> wrote in message
news:A7**********************************@microsof t.com...

I'm writting a page to send multi emails (just a few at a time, max 100)
once
a day.
should this be done using just a reader, or is there a way to do this with
a
dataset?
thanks
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes

[S. Justin Gengo]

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...tures/chester/

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"WebBuilder451" <We***********@discussions.microsoft.com> wrote in message
news:A7**********************************@microsof t.com...

I'm writting a page to send multi emails (just a few at a time, max 100)
once
a day.
should this be done using just a reader, or is there a way to do this with
a
dataset?
thanks
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes

[Mr Newbie]

I see your logic regarding loop action extending the time the loop takes to
complete, but my understanding is that the DataReader is quicker natively at
getting the data in that using the full compliment of data objects. I cant
substantiate this with impirical data but I have read as much in several
articles over the last few years.

Am I wrong in this assertion ?, and if so, then why ?

Regards - Mr N
"S. Justin Gengo" <justin@[no_spam_please]aboutfortunate.com> wrote in
message news:eF**************@tk2msftngp13.phx.gbl...

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...tures/chester/

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"WebBuilder451" <We***********@discussions.microsoft.com> wrote in message
news:A7**********************************@microsof t.com...

I'm writting a page to send multi emails (just a few at a time, max 100)
once
a day.
should this be done using just a reader, or is there a way to do this
with a
dataset?
thanks
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes

[Kevin Spencer]

You are correct.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Big things are made up of
lots of little things.

"Mr Newbie" <he**@now.com> wrote in message
news:uL**************@TK2MSFTNGP15.phx.gbl...

I see your logic regarding loop action extending the time the loop takes to
complete, but my understanding is that the DataReader is quicker natively
at getting the data in that using the full compliment of data objects. I
cant substantiate this with impirical data but I have read as much in
several articles over the last few years.

Am I wrong in this assertion ?, and if so, then why ?

Regards - Mr N
"S. Justin Gengo" <justin@[no_spam_please]aboutfortunate.com> wrote in
message news:eF**************@tk2msftngp13.phx.gbl...

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...tures/chester/

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"WebBuilder451" <We***********@discussions.microsoft.com> wrote in
message news:A7**********************************@microsof t.com...

I'm writting a page to send multi emails (just a few at a time, max 100)
once
a day.
should this be done using just a reader, or is there a way to do this
with a
dataset?
thanks
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes

[S. Justin Gengo]

Yes,

It will really depend on how many emails are being sent. A connection
shouldn't be opened for a long time, and therefore it's possible that a
datatable may be the better vehicle in this case.

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"Mr Newbie" <he**@now.com> wrote in message
news:uL**************@TK2MSFTNGP15.phx.gbl...

I see your logic regarding loop action extending the time the loop takes to
complete, but my understanding is that the DataReader is quicker natively
at getting the data in that using the full compliment of data objects. I
cant substantiate this with impirical data but I have read as much in
several articles over the last few years.

Am I wrong in this assertion ?, and if so, then why ?

Regards - Mr N
"S. Justin Gengo" <justin@[no_spam_please]aboutfortunate.com> wrote in
message news:eF**************@tk2msftngp13.phx.gbl...

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...tures/chester/

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"WebBuilder451" <We***********@discussions.microsoft.com> wrote in
message news:A7**********************************@microsof t.com...

I'm writting a page to send multi emails (just a few at a time, max 100)
once
a day.
should this be done using just a reader, or is there a way to do this
with a
dataset?
thanks
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes

[Mr Newbie]

Thanks for the validation on that point.

"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message
news:e2***************@TK2MSFTNGP10.phx.gbl...

You are correct.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Big things are made up of
lots of little things.

"Mr Newbie" <he**@now.com> wrote in message
news:uL**************@TK2MSFTNGP15.phx.gbl...

I see your logic regarding loop action extending the time the loop takes
to complete, but my understanding is that the DataReader is quicker
natively at getting the data in that using the full compliment of data
objects. I cant substantiate this with impirical data but I have read as
much in several articles over the last few years.

Am I wrong in this assertion ?, and if so, then why ?

Regards - Mr N
"S. Justin Gengo" <justin@[no_spam_please]aboutfortunate.com> wrote in
message news:eF**************@tk2msftngp13.phx.gbl...

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...tures/chester/

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"WebBuilder451" <We***********@discussions.microsoft.com> wrote in
message news:A7**********************************@microsof t.com...
I'm writting a page to send multi emails (just a few at a time, max
100) once
a day.
should this be done using just a reader, or is there a way to do this
with a
dataset?
thanks
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes