Hello,

I would like to have recommendations for the following.

I am going to develop a server application in VS.NET C# for sending SMS
messages thru SMPP connections.
I have three SMPP connections and they are always connected to the SMPP
server so they will be in a Windows Service.

The SQL Server will receive mobile numbers data from an ASP.NET web site
from the users.

My question, is what are the recommendations to pool the mobile numbers and
text SMS from DB and send SMS messages thru all three SMPP connections
without delay as I know I can pool sum data from DB each 10 seconds for
example but I am looking for something like to push the data as it arrived to
DB into the SMPP connections and also to let all the three connections to be
used for max send capacity.

Any advice will be much appreciated,
Asaf

Part of your solution is to use multiple threads. Any time you need to do
multiple bits of work (three connections at a time), you will need to divide
the work up. How to divide up the work is possibly the tricky part (I assume
you are sending the same message to everybody on the list when you send?).

Dividing the work into 3 piles is the simplest, but if one connection gets
bogged down the others will be idle towards the end of the run. This is not
a big deal in most instances, of course.

You could also round robin to the three threads. This is a bit more complex
possibly, but not much, as you are already working with multiple threads.

I am not quite to playing with this myself, but I would imagine some of the
open source gateways out there already have this functionality built in. As
you have your own SMPP connections wired in, it may not be an option without
rearchitecting.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

*************************************************
| Think outside the box!
|
*************************************************
[quoted text, click to view]