Mass SMS Capacity

[Abdlah]

I am creating an application with which to collate and report election results from about 21500 polling stations. I will be using Coldfusion 8 standard edition. I will have an ISP create the setup for me so that the SMSed results will be channeled to my access database for storage and for viewing.

I will be expecting a total of 43000 SMS messages within a short period of time (1 - 2 hours in the best case scenario).

What are issues I need to look out for so my system does not run into problems.

[Newsgroup_User]

Abdlah wrote:
> I will be expecting a total of 43000 SMS messages within a short period of
> time (1 - 2 hours in the best case scenario).
>
> What are issues I need to look out for so my system does not run into problems.

in standard edition, the SMS gateway is "limited to one shared simultaneous
request". have you load tested your worst case for your projected environment?
you also need to know how the sending SMS server reacts if your cf standard box
starts queuing requests--many SMS aggregators have quirks that makes working
w/them tricky.

for starters i'd reconsider access. it's really not meant for high transaction
environments. maybe postGres or mySql would be a better choice (or really any
big iron db your ISP supports).