Web services vs database access

[lmestre]

Hi,
I am designing a system and i need to publish a service, in order to
integrate different applications, my obvious answer is that it could be
a web service. But this service wil need about 500 requests per second
(xml size=100 kb). My question is how different is a store procedure
access than a web service access. How can i get reduce de
interdependences and have a good performance?

Thanx for any comment,
Luz

 

[David Sandor]

Hi,

Here are several benefits to using a web service for this scenario rather
than simply exposing a stored proc. 1)