473,385 Members | 1,958 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Mass emails

I need to email my client database of emails, but doing this is just too
slow:

...pseud code

while(have emails)
{
//fetch email
//preinitialised smtpclient object with host and message used
smtpclient.sendemail();
}

I have seen some complex codes written for mass emailing, why is the aboce
so slow and what are the issues with doing it this way? Could anyone point
me to the 'right' method? I already page my sql server via a stored proc to
bring back the data in 1000 record chunks.

I use asp.net 2 and c#

Thanks
Nov 26 '07 #1
11 1856
Hello,

I had a similar issue long time ago using .net fx 1.1, the workaround that
I found was to send an e-mail for each ten persons (then if you have 1000
contacts you will only send 100 e-mails), that worked perfect for me, I'm not
sure if I had to workaround the thing of getting several persons in the "To"
field (I think that didn't happened).

Good Luck
Braulio

PS: More Info about SMTP and ASP .net

http://www.tipsdotnet.com/ArticleBlo...TP&PageIndex=0
/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"PokerMan" wrote:
I need to email my client database of emails, but doing this is just too
slow:

...pseud code

while(have emails)
{
//fetch email
//preinitialised smtpclient object with host and message used
smtpclient.sendemail();
}

I have seen some complex codes written for mass emailing, why is the aboce
so slow and what are the issues with doing it this way? Could anyone point
me to the 'right' method? I already page my sql server via a stored proc to
bring back the data in 1000 record chunks.

I use asp.net 2 and c#

Thanks
Nov 26 '07 #2
Thank you for the reply....

I have 8100 people at present so i page 1000 at a time into the datareader,
loop it and send. If i add 10 people to the email ata time i think it does
then put all 10 in the To field. Unless i use bcc? And make the to field a
dummy address? What would be your best advice here?

i will investigate this method tho, thanks...anyone else with any other
methods or tips?
"Braulio Diez" <br**************@yahoo.eswrote in message
news:98**********************************@microsof t.com...
Hello,

I had a similar issue long time ago using .net fx 1.1, the workaround
that
I found was to send an e-mail for each ten persons (then if you have 1000
contacts you will only send 100 e-mails), that worked perfect for me, I'm
not
sure if I had to workaround the thing of getting several persons in the
"To"
field (I think that didn't happened).

Good Luck
Braulio

PS: More Info about SMTP and ASP .net

http://www.tipsdotnet.com/ArticleBlo...TP&PageIndex=0
/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"PokerMan" wrote:
>I need to email my client database of emails, but doing this is just too
slow:

...pseud code

while(have emails)
{
//fetch email
//preinitialised smtpclient object with host and message used
smtpclient.sendemail();
}

I have seen some complex codes written for mass emailing, why is the
aboce
so slow and what are the issues with doing it this way? Could anyone
point
me to the 'right' method? I already page my sql server via a stored proc
to
bring back the data in 1000 record chunks.

I use asp.net 2 and c#

Thanks

Nov 26 '07 #3
Try the several to's approach I think it doesn't show all the To's in every
mail (at least I think it was that way on system.web.mail).

Tell me if the approach works, if not we have to find another workaround :-)

/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"PokerMan" wrote:
Thank you for the reply....

I have 8100 people at present so i page 1000 at a time into the datareader,
loop it and send. If i add 10 people to the email ata time i think it does
then put all 10 in the To field. Unless i use bcc? And make the to field a
dummy address? What would be your best advice here?

i will investigate this method tho, thanks...anyone else with any other
methods or tips?
"Braulio Diez" <br**************@yahoo.eswrote in message
news:98**********************************@microsof t.com...
Hello,

I had a similar issue long time ago using .net fx 1.1, the workaround
that
I found was to send an e-mail for each ten persons (then if you have 1000
contacts you will only send 100 e-mails), that worked perfect for me, I'm
not
sure if I had to workaround the thing of getting several persons in the
"To"
field (I think that didn't happened).

Good Luck
Braulio

PS: More Info about SMTP and ASP .net

http://www.tipsdotnet.com/ArticleBlo...TP&PageIndex=0
/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"PokerMan" wrote:
I need to email my client database of emails, but doing this is just too
slow:

...pseud code

while(have emails)
{
//fetch email
//preinitialised smtpclient object with host and message used
smtpclient.sendemail();
}

I have seen some complex codes written for mass emailing, why is the
aboce
so slow and what are the issues with doing it this way? Could anyone
point
me to the 'right' method? I already page my sql server via a stored proc
to
bring back the data in 1000 record chunks.

I use asp.net 2 and c#

Thanks


Nov 26 '07 #4
It doesn't shed any light about the multiple "To's" issue, but I would try this

http://weblogs.asp.net/scottgu/archi...10/432854.aspx

I know is very basic, but worth to give a try.

--
/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"Braulio Diez" wrote:
Hello,

I had a similar issue long time ago using .net fx 1.1, the workaround that
I found was to send an e-mail for each ten persons (then if you have 1000
contacts you will only send 100 e-mails), that worked perfect for me, I'm not
sure if I had to workaround the thing of getting several persons in the "To"
field (I think that didn't happened).

Good Luck
Braulio

PS: More Info about SMTP and ASP .net

http://www.tipsdotnet.com/ArticleBlo...TP&PageIndex=0
/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"PokerMan" wrote:
I need to email my client database of emails, but doing this is just too
slow:

...pseud code

while(have emails)
{
//fetch email
//preinitialised smtpclient object with host and message used
smtpclient.sendemail();
}

I have seen some complex codes written for mass emailing, why is the aboce
so slow and what are the issues with doing it this way? Could anyone point
me to the 'right' method? I already page my sql server via a stored proc to
bring back the data in 1000 record chunks.

I use asp.net 2 and c#

Thanks

Nov 26 '07 #5

"PokerMan" <no****@pokercat.co.ukwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...
Thank you for the reply....

I have 8100 people at present so i page 1000 at a time into the
datareader, loop it and send. If i add 10 people to the email ata time i
think it does then put all 10 in the To field. Unless i use bcc? And make
the to field a dummy address? What would be your best advice here?

i will investigate this method tho, thanks...anyone else with any other
methods or tips?
put the addresses in BCC unless you want all the recipients to know who else
got the email ... even if you don't care, it looks sloppy on the TO line and
may get spam-trapped if this is external mail

so how slow is "slow" ? could be you're ok and could be that BCC'ing and
the like is ducking the issue of figuring out a more efficient way to do the
job, which you may or may not care about ....
"Braulio Diez" <br**************@yahoo.eswrote in message
news:98**********************************@microsof t.com...
>Hello,

I had a similar issue long time ago using .net fx 1.1, the workaround
that
I found was to send an e-mail for each ten persons (then if you have 1000
contacts you will only send 100 e-mails), that worked perfect for me, I'm
not
sure if I had to workaround the thing of getting several persons in the
"To"
field (I think that didn't happened).

Good Luck
Braulio

PS: More Info about SMTP and ASP .net

http://www.tipsdotnet.com/ArticleBlo...TP&PageIndex=0
/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"PokerMan" wrote:
>>I need to email my client database of emails, but doing this is just too
slow:

...pseud code

while(have emails)
{
//fetch email
//preinitialised smtpclient object with host and message used
smtpclient.sendemail();
}

I have seen some complex codes written for mass emailing, why is the
aboce
so slow and what are the issues with doing it this way? Could anyone
point
me to the 'right' method? I already page my sql server via a stored proc
to
bring back the data in 1000 record chunks.

I use asp.net 2 and c#

Thanks


Nov 26 '07 #6
As another person asked, how slow is "slow"? We occasionally send about 3000
and it takes 30-45 minutes.

What exactly are you doing in "preinitialised smtpclient object with host
and message used"? More specifically, are you disconnecting and
re-connecting to the SMTP server every time? All you need to do is change
the "TO" line (and perhaps the message body, if desired) and send the new
email.

If all else fails, consider using a list service instead.

Scott
>I have 8100 people at present
>>>I need to email my client database of emails, but doing this is just
too
slow:

...pseud code

while(have emails)
{
//fetch email
//preinitialised smtpclient object with host and message used
smtpclient.sendemail();
}

Nov 26 '07 #7
Yep thats exactly what i am doing.

By pre-init, as in host doesnt change, from doesnt change etc. So i just doa
smtpclient.send in aloop, and i am getting similar time frames, which to me
is quite poor? On the 8k ppl i geta time out and it runs for along time,
what about huge databases of 100k plus people, how do they do it? If 3k ppl
takes 30 minutes, thats 100 every minute, so a 100k ppl is 16hrs plus! There
must be a more efficient way surely? My database is growing rapidly and i am
worrying aboutt he scalability of my solution? Any ideas?

For now i will try the bcc and bulk them in so a load go with one smtp
client send and try and improve it that way.

Thanks in advance, i look forward to hearing other methods

"Scott Roberts" <sr******@no.spam.here-webworks-software.comwrote in
message news:eo**************@TK2MSFTNGP03.phx.gbl...
As another person asked, how slow is "slow"? We occasionally send about
3000 and it takes 30-45 minutes.

What exactly are you doing in "preinitialised smtpclient object with host
and message used"? More specifically, are you disconnecting and
re-connecting to the SMTP server every time? All you need to do is change
the "TO" line (and perhaps the message body, if desired) and send the new
email.

If all else fails, consider using a list service instead.

Scott
>>I have 8100 people at present
>>>>I need to email my client database of emails, but doing this is just
too
slow:
>
...pseud code
>
while(have emails)
{
//fetch email
//preinitialised smtpclient object with host and message used
smtpclient.sendemail();
}
>


Nov 26 '07 #8
On the 8k ppl i geta time out and it runs for along time,
what about huge databases of 100k plus people, how do they do it? If 3k
ppl takes 30 minutes, thats 100 every minute, so a 100k ppl is 16hrs plus!
There must be a more efficient way surely? My database is growing rapidly
and i am worrying aboutt he scalability of my solution? Any ideas?
Is there a particular reason that time is a problem?

As I mentioned before, you might look into a list service. I'm guessing that
there is tighter integration with the mail server and speeds are much
better.

Nov 26 '07 #9
On Nov 26, 2:46 pm, "PokerMan" <nos...@pokercat.co.ukwrote:
I need to email my client database of emails, but doing this is just too
slow:

..pseud code

while(have emails)
{
//fetch email
//preinitialised smtpclient object with host and message used
smtpclient.sendemail();

}

I have seen some complex codes written for mass emailing, why is the aboce
so slow and what are the issues with doing it this way? Could anyone point
me to the 'right' method? I already page my sql server via a stored proc to
bring back the data in 1000 record chunks.

I use asp.net 2 and c#

Thanks
Where the SMTP server is located, on the same server?
Nov 26 '07 #10
No its not.
Nov 26 '07 #11
Well my site seems to time out which is why i want it shorter. I have it set
now not to time out but it still seems to eventually break when it runs too
long (into the hours). So i wnt it to run shorter if possible.

"Scott Roberts" <sr******@no.spam.here-webworks-software.comwrote in
message news:eB**************@TK2MSFTNGP05.phx.gbl...
>
>On the 8k ppl i geta time out and it runs for along time,
what about huge databases of 100k plus people, how do they do it? If 3k
ppl takes 30 minutes, thats 100 every minute, so a 100k ppl is 16hrs
plus! There must be a more efficient way surely? My database is growing
rapidly and i am worrying aboutt he scalability of my solution? Any
ideas?

Is there a particular reason that time is a problem?

As I mentioned before, you might look into a list service. I'm guessing
that there is tighter integration with the mail server and speeds are much
better.

Nov 26 '07 #12

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Aplus | last post by:
Hi, I am web admin for a school's website and now and again I have to send emails to those who have signed the guestbook and have consented to this. Now I have a distribution list within outlook...
3
by: Strasser | last post by:
In Access2000 mass emailing worked perfectly (very powerful tool!). Doesn't work when using XP version of both Access and Outlook, even though I checked the box to ensure that I was sending the...
3
by: Gil \(Asp.net Developer\) | last post by:
1
by: johnny | last post by:
hi all, I would like to understand which are the best ways to send bulk mailings like for newsletters and so on ( not spamming, always to receivers who opt-in ). I am not looking for code for...
1
by: giesss | last post by:
I have been searching for a way to call a third party emailer to send mass emails from MS Access. Outlook thinks it is spam and asks the user to verify every email. I need to send many emails with an...
3
by: cordial_camaraderie | last post by:
I need to send 30,000 emails to our NewsLetter Subscriber, I tried to use our hosting Site and for the worst part We we banned and our site was stopped. I am using PHP script, mail() function to...
2
by: Bob Alston | last post by:
I am looking for suggestions for software or access code or utilities to assist in doing mass emailings from an Access database. The emailings would likely be a few thousand at a time. Generally...
2
by: forrestgump | last post by:
I am curently trying to find a way of sending out mass emails from access. I have located VBA for generating emails directly into outlook but I have to click send on each one. Is there a way so the...
0
by: PokerMan | last post by:
Hi guys Can anyone tell me the best way to implement a mass email newshot, to 1million plus people! I have done this: 1) Set up a news email account on my server 2) Set that email as the...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.