| Author |
Message
|
| jeeth_m |
 Posted: Tue Aug 26, 2008 5:28 am Post subject: webservice response time |
 |
|
Voyager
Joined: 21 Jan 2002
Posts: 93
|
Hi,
I have webservice hosted on message broker. Responsibility of the service is to query database and respond back to requestor.
Issue is first time i call the service it takes 4 seconds to respond back. Subsequent request(if sent Immediately) takes just .2 seconds or less. If i wait for 2 minutes and send another request it again takes 4 seconds.
Since the webservice is not called frequently during business hours i am guessing its going to take 4 seconds each time it is called.
Is there any configuration i need to change to get a quicker response even if it is the first call?
I have seen similar post ion this forum before but am unable to locate it.
Regards,
Jeeth |
|
| Back to top |
|
 |
| jeeth_m |
| Posted: Wed Aug 27, 2008 12:24 am Post subject: |
|
|
Voyager
Joined: 21 Jan 2002
Posts: 93
|
|
| Back to top |
|
|
| Gaya3 |
| Posted: Wed Aug 27, 2008 12:39 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
if you are calling frequently, it will cache your third part requests, thats all
you can think of tuning your application,
reade Broker tuning PDF for more clarity
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| jeeth_m |
| Posted: Wed Aug 27, 2008 6:44 am Post subject: |
|
|
Voyager
Joined: 21 Jan 2002
Posts: 93
|
Here is a sample xml i am using.
<Body>
<Findcustomer>
<PartyID>123</PartyID>
<PartyNumber>123</PartyNumber>
</Findcustomer>
<Findcustomer>
<PartyID>123</PartyID>
<PartyNumber>ABC</PartyNumber>
</Findcustomer>
</Body>
I am using procedure to call database stored procedure.
Since the tag Findcustomer occurs twice i am calling the stroed procedure two times to get the results back.
Is there any way i can pass an array to stored procedure so that i make only one call and get the result in a result set? |
|
| Back to top |
|
|
| broker_new |
| Posted: Wed Aug 27, 2008 6:24 pm Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
recently i had a very similar requirement as jeeth_m had.....
In this case i think going for a webservice is may not be the correct way of designing this because the webservice is totally dependent on the response of the stored procedure and we may end up timing out of Webservice ....
we may not know where we may end up because of the stored procedure response .....it it is less than few seconds its perfect..... |
|
| Back to top |
|
|
| jeeth_m |
| Posted: Thu Aug 28, 2008 4:35 am Post subject: |
|
|
Voyager
Joined: 21 Jan 2002
Posts: 93
|
| my stored procedure is giving me a good response time. I checked it by calculating the response time. even the whole webservice is giving me a good response time except for the first call. First call to WS is taking way lots of time. |
|
| Back to top |
|
|
| francoisvdm |
| Posted: Mon Sep 01, 2008 2:34 am Post subject: |
|
|
Partisan
Joined: 09 Aug 2001
Posts: 332
|
Maybe this is normal web service behaviour? Do you know how many seconds between calls will put web service in this "slow" state? If say it is 120 seconds, then just create a timer flow that calls this web service every 115 seconds with "dummy" data that will result in minimum impact on system. Very artificial, I know, but it will keep the web service "alive" so that when you call it from your real flow the response will be fast.
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.
Francois van der Merwe |
|
| Back to top |
|
|
|
|
