Print Page | Close Window

Network latency and database access

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=3442
Printed Date: 05-Sep-2025 at 1:54pm


Topic: Network latency and database access
Posted By: FranklinKyleJ
Subject: Network latency and database access
Date 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?


Replies:
Posted By: DenisK
Date 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 - 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?


Print Page | Close Window