about subscribers

i have millions of subscribers,

any good idea to manage those subscribers efficently?

thanks

Same old, same old... Query optimization (the most important thing!!!...).

And remember that you can add custom indexes to NS tables.

Also, if possible, break your application into several separate applications based on the module's functionality, and run them separately, maybe even on separate machines.

Also, for performance, use SQL Server server machine for the SQL stuff only, and move the NS service and all other resources-hungry stuff (custom event providers, content formatters, etc.) to other server(s).

Use subscription expiration to remove all "old" subscriptions, and once in a while prompt your customers to confirm their old subscriptions (that they still want to receive their alerts AND confirm email addresses, cell phone #s, etc.). Maybe, even distribute your own notification with the request for confirmation; do it a few times; if someone does not reply, remove this subscriber.

|||

Thanks for that,and

Any good idea about how to create subscribers quickly,especially millions of subscribers

|||

For SSNS in 2000, you have to use the API.

In SSNS 2005, you can insert into subscriber views. Here's an example.

http://sqlns.blogspot.com/2005/10/creating-subscribers-in-2005.html

HTH...

Joe