.Net application call a stored procedure directly or should a .Netapplication call a web service, or is WCF better

Nexstar

What is the fastest way to access the database for performance point
of view? Should a .Net application call a stored procedure directly or
should a .Net application call a web service, or use WCF, or is there
another way?

Feb 20 '08 #1

Subscribe Post Reply

1426

John Saunders [MVP]

"Nexstar" <br**********@yahoo.comwrote in message
news:fe**********************************@i12g2000 prf.googlegroups.com...

What is the fastest way to access the database for performance point
of view? Should a .Net application call a stored procedure directly or
should a .Net application call a web service, or use WCF, or is there
another way?

"It depends"? There's not going to be a single answer for this.

Of course, it makes sense that less overhead is better. But what "makes
sense" is not always true.
--
--------------------------------------------------------------------------------
John Saunders | MVP - Windows Server System - Connected System Developer

Feb 20 '08 #2

Eric

On Feb 19, 10:40*pm, Nexstar <brettreed...@yahoo.comwrote:

What is the fastest way to access the database for performance point
of view? Should a .Net application call a stored procedure directly or
should a .Net application call a web service, or use WCF, or is there
another way?

I vote for a direct call being the fastest. Any of the other solutions
you mentioned would add more baggage.

Eric

Feb 21 '08 #3

Similar topics

webservice call using MSXML2.HTTP

by: Patrick | last post by:

I am almost certain that I could use HTTP Post/Get to submit XML Web Service call (over SSL as well, if using Version 3 of MSXML2) from an ASP Application? However, would I only be able to call...

ASP / Active Server Pages

Function to call function by name given as parameter

by: Mariusz | last post by:

I want to write function to call another function which name is parameter to first function. Other parameters should be passed to called function. If I call it function('f1',10) it should call...

Microsoft SQL Server

High Level View of a .Net Application

by: Shawn Brock | last post by:

This is a wildly broad question, so apologies in advance. I developed a very traditional app architecture in Visual Studio 5-6. The basic structure looked like this: GUI >> MTS >> Database The...

.NET Framework

SQL Access security from Window Application

by: John J. Hughes II | last post by:

I am having some major problem with maintaining security for my windows application to the SQL. Currently my application access the SQL using System.Data.SqlClient and all forms use stored...

.NET Framework

CLI0119E from "call sqlj_install_jar()" in PHP

by: Larry Menard | last post by:

Test code: $dbconn = odbc_connect($dbname, $username, $password); $path = "C:\Temp\myJar.jar"; $statement = "CALL SQLJ.INSTALL_JAR('file://$path', 'myJarId')"; $result = odbc_exec($dbconn,...

DB2 Database

Reference a dll in a separate web application/directory

by: benliu | last post by:

i have a visual studio website that i am integrating with community server, a third party software for creating communities. To paraphrase, i am trying to have users that log in to my site...

ASP.NET

Remote Desktop Affects Windows Application on network interruption

by: =?Utf-8?B?TVNU?= | last post by:

To demonstrate my problem, I have a very simple VB Windows application. It has a text box that is used to display a counter, a button to reset the counter, and a timer that increments the counter...

.NET Framework

Windows Application + Web Services

by: Sylvie | last post by:

My Windows Application has two forms, one form contains a grid (lets say Stock Listing), and the other is a form of one stock, contains some edit boxes for one stock's fields.. Is it possible to...

C# / C Sharp

Web service to call sql stored procedure

by: barmatt80 | last post by:

I don't know if this is the right part of the forum. But.... I have been working all night trying to create a web service to call a stored procedure in sql server 2008. The stored procedure calls...

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General