DevForce Community Forum : Network latency and database access http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Network latency and database access Mon, 13 Apr 2026 14:21:00 -700 Thu, 17 May 2012 13:19:48 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3442 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Network latency and database access : Hi FranklinKyleJ,A few things:1.... http://www.ideablade.com/forum/forum_posts.asp?TID=3442&PID=13591#13591 Author: DenisK
Subject: 3442
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?
]]> Thu, 17 May 2012 13:19:48 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3442&PID=13591#13591 Network latency and database access : We have noticed an issue in ourproductionsystem... http://www.ideablade.com/forum/forum_posts.asp?TID=3442&PID=13585#13585 Author: FranklinKyleJ
Subject: 3442
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?
]]> Wed, 16 May 2012 09:22:21 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3442&PID=13585#13585