Click here to Skip to main content
15,913,773 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionProblem with webservice that runs threaded [modified] Pin
FarmerHE20-May-10 3:23
FarmerHE20-May-10 3:23 
AnswerRe: Problem with webservice that runs threaded Pin
Martin Jarvis20-May-10 6:03
Martin Jarvis20-May-10 6:03 
GeneralRe: Problem with webservice that runs threaded Pin
FarmerHE20-May-10 6:24
FarmerHE20-May-10 6:24 
GeneralRe: Problem with webservice that runs threaded Pin
Martin Jarvis20-May-10 6:31
Martin Jarvis20-May-10 6:31 
GeneralRe: Problem with webservice that runs threaded Pin
FarmerHE20-May-10 6:41
FarmerHE20-May-10 6:41 
GeneralRe: Problem with webservice that runs threaded Pin
T M Gray20-May-10 9:36
T M Gray20-May-10 9:36 
GeneralRe: Problem with webservice that runs threaded Pin
FarmerHE20-May-10 10:48
FarmerHE20-May-10 10:48 
AnswerRe: Problem with webservice that runs threaded Pin
The Man from U.N.C.L.E.20-May-10 6:40
The Man from U.N.C.L.E.20-May-10 6:40 
If we have any calls longer than about a second we tend to hand them off to another process in SQL.

The Webservice submits the request to SQL which stores the request, we then use SQL Service Broker to trigger processing of that request, which is then on another SQL thread and independent of the webservice which has long since returned. For really long SQL jobs (over 20 seconds) we have a scheduled job pick up the stored request for processing.

If your webservice call takes longer than a few seconds you are using the wrong technology.

Having said that, we once had a task that processed over 16 million financial transactions and ran for several weeks. Migrating to SQL (it was FoxPro) brought it down to hours, and fixing the crap SQL brought it down to under a minute. So the problem may be in the processing not the technology.
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
[My Articles]  [My Website]

GeneralRe: Problem with webservice that runs threaded Pin
FarmerHE20-May-10 6:52
FarmerHE20-May-10 6:52 
GeneralRe: Problem with webservice that runs threaded Pin
The Man from U.N.C.L.E.20-May-10 7:09
The Man from U.N.C.L.E.20-May-10 7:09 
GeneralRe: Problem with webservice that runs threaded Pin
FarmerHE20-May-10 7:19
FarmerHE20-May-10 7:19 
QuestionIE8 issue--URGENT PLZZZZ.... Pin
chetan_agarwal20-May-10 2:59
chetan_agarwal20-May-10 2:59 
AnswerRe: IE8 issue--URGENT PLZZZZ.... Pin
Yusuf20-May-10 3:05
Yusuf20-May-10 3:05 
GeneralRe: IE8 issue--URGENT PLZZZZ.... Pin
chetan_agarwal20-May-10 19:12
chetan_agarwal20-May-10 19:12 
GeneralRe: IE8 issue--URGENT PLZZZZ.... Pin
FarmerHE20-May-10 19:53
FarmerHE20-May-10 19:53 
GeneralRe: IE8 issue--URGENT PLZZZZ.... Pin
chetan_agarwal20-May-10 20:05
chetan_agarwal20-May-10 20:05 
AnswerRe: IE8 issue--URGENT PLZZZZ.... Pin
Not Active20-May-10 5:45
mentorNot Active20-May-10 5:45 
GeneralRe: IE8 issue--URGENT PLZZZZ.... Pin
Martin Jarvis20-May-10 6:04
Martin Jarvis20-May-10 6:04 
GeneralRe: IE8 issue--URGENT PLZZZZ.... Pin
Not Active20-May-10 7:06
mentorNot Active20-May-10 7:06 
AnswerRe: IE8 issue--URGENT PLZZZZ.... Pin
Martin Jarvis21-May-10 2:10
Martin Jarvis21-May-10 2:10 
QuestionError on the live Server Pin
yogesh_kumar_agarwal20-May-10 2:45
yogesh_kumar_agarwal20-May-10 2:45 
AnswerRe: Error on the live Server Pin
Yusuf20-May-10 3:03
Yusuf20-May-10 3:03 
QuestionMessage Removed Pin
20-May-10 2:36
tamilpuyal_2820-May-10 2:36 
AnswerRe: Display the menu control, treeview control, site map control in a weird way Pin
Sandeep Mewara20-May-10 8:03
mveSandeep Mewara20-May-10 8:03 
Questionread page and don't stop Pin
buffering8320-May-10 0:16
buffering8320-May-10 0:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.