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

About SQL Server 2005 Express

I developed a small application to manage inventory, accounting, payroll and so, for up to 5 users, running on SQL DB. Now I have some people interested for the software, they want to use it in their small companies. If I sell them the solution, do they have to license SQL DB ? or can they use express edition for free ?

You can distribute (or they can download and install) SQL 2005 Express. It is FREE.

You may wish to check out this resource:

SQL Server 2005 Express Redistribution
http://www.microsoft.com/sql/editions/express/redistregister.mspx