Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mikejohnson
Posting Yak Master
153 Posts |
 Posted - 2004-11-15 : 12:59:26
|
| i have a database of email addresses. once a customer adds a product onto our website i'd like to email everyone in the database a notification the product has been added. is there a way to select all the addresses fast so i can send out one email and bcc them? or what's the best way to do this so the asp page doesn't take forever to load and sql runs fast at the same time? |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-11-15 : 13:24:56
|
| Well, with the selecting of the addresses, there's probably not too many ways you can do that. You'll probably be scanning an index to get every e-mail address for every customer.As far as the e-mailing part, how is that implimented? It looks like you said it's done in ASP. If it were ASP.net I'd say kick the emailing off into a thread and you are done. For ASP 3.0, I'd probably write a record to a table someplace that is polled by an EXE / Service that does the e-mailing.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-11-15 : 13:34:07
|
| Do these people want to know every time something is added?reminds me of a python skit....bloody vikings....Brett8-) |
|
|
|
mikejohnson
Posting Yak Master
153 Posts |
Posted - 2004-11-15 : 13:45:29
|
| we have a process where customers can select whether to receive notifications or not. thanks for the help |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-16 : 00:35:47
|
| Scheduled task that runs, say, once an hour and sends out any "new" emails?Kristen |
|
|
|
|
|
|
bulk emailing/addresses