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 |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
 Posted - 2005-04-02 : 09:37:26
|
| HelloIs it possible to run a serverside proces from ASP.I have a script that posts an SMS (web2phone) script to another ASP Page which in turn does a loop depending on how many CSV (Comma seperated values)The user chooses.I use a SP to parse the CSV values into my db, but to the values to my provider, am using an XMLHTTP Request script. Which loops over and over again depending on the number of CSV values there are.A user can choose well over 10,000 - 100,000 values.whats the most efficient way to loop on my serversidethanksAfrika |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-02 : 09:54:05
|
| You should contact the SMS service provider to find out if they offer a method to process large numbers of messages like you're describing. Otherwise, there is no "efficient" way to loop, you just loop normally. As long as you are keeping the database out of it, and you have some way of running this process independently and asynchronously from the rest of the program. Otherwise it will grind to a halt long before you process 1,000.I personally would limit the number of messages that could be sent via one request anyway. If someone could choose 100,000 to send, your application will become a spammer's dream. If this is a requirement, it needs to be questioned. |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-04-02 : 10:01:20
|
| oh ok Thanks robvolk |
|
|
|
|
|
|
Is it possible to run a serverside proces from ASP