I agree with Peter 100%  on this.  Currently I am working on a project that
describes exactly what you wrote.  I have a WinForm application accessing
the database through a WebService.  We've ran a couple of tests regarding
data retrieval natively from WinForms and through the WebService and while
the WebService was slower (by a few milliseconds) you don't really notice
the slow down in your application; however Peter is right; it also comes
down to what else the WebService will be doing.  Will it only retrieve the
data from the database for you or will it manipulate that data also ?
I work in the financial sector and I've seen quite a few trading system that
user WebServices for partial or complete data access because A) WebServices
are fairly easy to develop and maintain and B) no additional ports need to
be opened up (big banks are more willing to work with you more if there are
no port open requests coming from you).  And while putting a SQL Server on
the Internet can be a risk it all depends on how you set it up.  If your
resident SQL expert is really good he/she can lock it down tight; however it
is very rare that companies leave a SQL database open on the net for clients
to access, the preferred way to go is access through a WebService.

-Pete

On 4/17/07, Peter Ritchie <
[EMAIL PROTECTED]> wrote:

Adding a web service intermediary between an application and SQL Server is
always going to be slower.  How much slower depends on how the web service
was written, unless the web service does some sort of value-added
processing (like being an entity broker or something) or caching.

There's nothing less secure about putting a SQL Server on the Internet.
The communication can be on port 80 and can also be encrypted and can use
integrated Windows authentication.  The only difference is that it's
interface isn't proprietary like a web service.

===================================
This list is hosted by DevelopMentor(r)  http://www.develop.com

View archives and manage your subscription(s) at
http://discuss.develop.com


===================================
This list is hosted by DevelopMentorĀ®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

Reply via email to