New Posts New Posts RSS Feed: Network latency and database access
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Network latency and database access
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
FranklinKyleJ View Drop Down
Newbie
Newbie


Joined: 16-May-2012
Posts: 1 		Post Options Post Options   Quote FranklinKyleJ Quote  Post ReplyReply Direct Link To This Post Topic: Network latency and database access
    Posted: 16-May-2012 at 9:22am
We have noticed an issue in our production system using devforce that each query is making a ton of 'hops' around the network sending the data across and sending TCP responses back.  In testing environments it isn't an issue as we have very little latency between the application and the network. Once we get on site, and see latency go upwards of 200ms - 500ms we notice an appreciable difference in the response time of our application.

Is there anything in devforce, settings or strategies we can use to help improve this situation or does this seem like a network problem on the companies end?
Back to Top
DenisK View Drop Down
IdeaBlade
IdeaBlade


Joined: 25-Aug-2010
Posts: 715 		Post Options Post Options   Quote DenisK Quote  Post ReplyReply Direct Link To This Post Posted: 17-May-2012 at 1:19pm
Hi FranklinKyleJ,

A few things:

1. What do you mean by hops? Is it network hops or query hops? By query hops, I mean that if your query is complex with many selects clause, for example, then it can trigger multiple queries when you expect it to be just one query.

2. Try analyzing the queries with DevForce Fiddler Extension. http://drc.ideablade.com/xwiki/bin/view/Documentation/fiddler.

3. SSL tunneling can reduce TCP overhead.

4. Could you give more info as to how your deployment is configured? Are you using IIS or Windows Service? Are the BOS and the Sql db on the same box?
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down