Post reply

stored procedure vs view

  • July 16, 2006 at 10:32 pm

    #91142

    Dear guys...

    Now, I am faced a problem from the application that i maintained. The application is developed by the previous programmer using a sql statement submitted directly to the server each time retrieve a row data. As the database grows, the application is slower and slower, and our user is begin to complaint.

    I try to update the source code by changing the way the applicationi retrieve the data by  using stored procedure or views.

    What is more capable, using a stored procedure or a views? to minimize the workload of a network.

    thx in advance for the help...

     

     

  • July 17, 2006 at 1:23 am

    #649464

    Hi,

    I'd advise that you use stored procedures - for a variety of reasons.

    Essentially, by using stored procedures you can more effectively handle security, network traffic is reduced, execution plan is cached. And a host of other reasons.

    Karl
    source control for SQL Server

  • July 17, 2006 at 11:46 pm

    #649713

    Hi Karl,

    Thx for the answer...

    Ady

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply