Remoting/Web service/sqlClient performance

  • Thread starter Thread starter millner,kim
  • Start date Start date
M

millner,kim

Hi,
In our project we are using sqlClient to communicate with the database
server(SQL Server 2005). It's running great.
Our project is doing lots of sql queries.
We are planning to put our code in the web server or a remote server and use
remoting to do the query.
I want to know, is it going to effect the performance if we do like this.
What other problems we might face doing like this.

We need some experts comments and suggestion before we perform this task.

Thanks
Kim
 
The TDS link to a network-based SQL Server is fairly efficient. When working
with any remote architecture, you should still pay attention to round trips
and what's being transported over the wire. I suspect you'll want to
carefully consider binary remoting format to maximize performance and keep
an eye on how the (remote) connections are being managed. In any case, I
would try to build a prototype and test it pretty heavily before trying to
implement the whole magilla. Will it be as fast? I doubt it--no matter how
well you design it. Will it scale up better? Yes, it could if you're clever.
Just remember to keep the web traffic to a minimum. Do as much work on
either end and transport as little data as possible.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top