Re: Advatages of Stored Procedures?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Speed and performance are the reasons to use stored proc.

If you are processing thousands of records and preparing a report then
stored proc will be much faster then fetching all the records and
processing in .net application.

But if the number of concurrent users are also in thousands then as all
the stored proc will be on one server only then its disadvantage.

We use stored proc a lot in our application where concurrent users are
less then 100 and all data crunching processing is done in stored proc
and performance is very good.

Vinod

.

Relevant Pages

  • Re: Reflexive table problem - tricky
    ... Have you considered calling the stored proc directly from the ... >> as Input to a Crystal Report. ... >> procedure but a table Function wont let me call the Procedure so I am ... >> ID int PRIMARY KEY, ...
    (microsoft.public.sqlserver.programming)
  • Parameter fields order changes
    ... I have a report which accepts 2 stored proc parameter fields A ... The report has been verfied each time the order was changed. ... but an SQL server error is always raised. ... It seems that CR still retains the parameter order somewhere. ...
    (microsoft.public.vb.crystal)
  • Re: Running a stored proc that will take a while.
    ... error handling elsewhere so all I have to do is submit the stored proc ... If the sproc in question returns a report, you can also consider Reporting Services and queue up the report. ... Also, if the OP is using SQL Server 2005 or higher, he could use SQL Server Broker, sending a message to a queue to run the sporc that would be ran async. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Running a stored proc that will take a while.
    ... error handling elsewhere so all I have to do is submit the stored proc ... You can also spin up a thread and run the sproc from there. ... you will need an event handler to handle the end ... Reporting Services and queue up the report. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Help!
    ... > I have a Crystal report that calls a SQL Server stored proc. ... Then I added a subreport in the Report Footer ...
    (microsoft.public.vb.crystal)