Email service

[neeraj]

I have made a service which picks up records from a table which has
following columns :From,to,subject,body,status
The service, after picking up the records, loops through all the
records and sends the email for each record and updates the status as
1.

The problem is that my service fails when the record size is about
20000-25000.

Any one can suggest me a method so that i can send 20000-25000 with in
1 or 2 hours

[rowe_newsgroups]

Wait is the purpose of sending all those emails?

Thanks,

Seth Rowe

On Jan 24, 7:03 am, "neeraj" <[e-mail]:

I have made a service which picks up records from a table which has
following columns :From,to,subject,body,status
The service, after picking up the records, loops through all the
records and sends the email for each record and updates the status as
1.

The problem is that my service fails when the record size is about
20000-25000.

Any one can suggest me a method so that i can send 20000-25000 with in
1 or 2 hours

[Phill W.]

neeraj wrote:

The problem is that my service fails when the record size is about
20000-25000.

Any one can suggest me a method so that i can send 20000-25000 with in
1 or 2 hours

*Why* would you want to send 25,000 emails?
Either you're /very/ successful and have /lots/ of customers that you
need to communicate with or you're trying to clog up the web with yet
more junk mail.

25,000 isn't a number that's significant in computing terms (like, say,
32,767) so I'm guessing it's purely a volume-related thing.

Regards,
Phill W.

[neeraj]

The purpose of sending a lot of mails is, actually I receiving the data
from various branches of my company in a ".csv" file I just import
the that "csv" file in my sql database.
When all records got imported in data base I select the email id of all
imported data and start the service for sending his "user id" and
"Password" to registered users,

But mail sending service not working fine when amount of records is to
large. It throws "System.OutofMemoryException" when amount of
record reaches above 3000.
On Jan 24, 5:08 pm, "rowe_newsgroups" <[e-mail]:

Wait is the purpose of sending all those emails?

Thanks,

Seth Rowe

On Jan 24, 7:03 am, "neeraj" <[e-mail]:

I have made a service which picks up records from a table which has
following columns :From,to,subject,body,status
The service, after picking up the records, loops through all the
records and sends the email for each record and updates the status as
1.

The problem is that my service fails when the record size is about
20000-25000.

Any one can suggest me a method so that i can send 20000-25000 with in
1 or 2 hours- Hide quoted text -- Show quoted text -

[rowe_newsgroups]

Now that I'm fairly sure you're not spamming...

I know I'm not directly fixing your problem here, but why not have the
user's write directly to the database? All those attached csv files has
got to be killing your email server (if I did that here, our IT Manager
would get out his baseball bat and come after me!). Then if the
database has a notification feature, like MS Sql Server does, have it
send out the user id / password emails. That way there aren't thousands
of email flying around and resource heavy services running.

Thanks,

Seth Rowe

On Jan 25, 1:48 am, "neeraj" <[e-mail]:

The purpose of sending a lot of mails is, actually I receiving the data
from various branches of my company in a ".csv" file I just import
the that "csv" file in my sql database.
When all records got imported in data base I select the email id of all
imported data and start the service for sending his "user id" and
"Password" to registered users,

But mail sending service not working fine when amount of records is to
large. It throws "System.OutofMemoryException" when amount of
record reaches above 3000.

On Jan 24, 5:08 pm, "rowe_newsgroups" <[e-mail]:

Wait is the purpose of sending all those emails?

Thanks,

Seth Rowe

On Jan 24, 7:03 am, "neeraj" <[e-mail]:

I have made a service which picks up records from a table which has
following columns :From,to,subject,body,status
The service, after picking up the records, loops through all the
records and sends the email for each record and updates the status as
1.

The problem is that my service fails when the record size is about
20000-25000.

Any one can suggest me a method so that i can send 20000-25000 with in
1 or 2 hours- Hide quoted text -- Show quoted text -

[Phill W.]

neeraj wrote:

When all records got imported in data base I select the email id of all
imported data and start the service for sending his "user id" and
"Password" to registered users,

Not too sure I'd want those flying around in "Email-World". It might be
better to keep them in-house and direct your users to a secure web page
where they can collect them. But anyway...

But mail sending service not working fine when amount of records is to
large. It throws "System.OutofMemoryException" when amount of
record reaches above 3000.

Then you need to send them in smaller subsections.
Send a "batch", let your service take a breather to let the mail system
push those messages out the door, then do the next "batch".

How are you actually sending the messages?

Regards,
Phill W.