sotred proc' vs views

Results 1 to 2 of 2

Thread: sotred proc' vs views

  1. #1
    Join Date
    Dec 1969

    Default sotred proc' vs views

    is there any advantage in using stored proceures as opposed to views -0 does one run faster than the other - for instanse if i have a view which may be failry complex sql then in asp i can chuck it <BR>strsql="select * from myview where id = " & id<BR>and open the recordset like that<BR><BR>OR <BR><BR>I can set up a stored procedure with the same sql <BR>and a parameter and call the sp_myproc id from asp <BR><BR><BR>they both return the same - but i cannot see what the big difference is ??<BR><BR>thanks ;~)<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default pre-compiled vs compiled?

    A view is re-compiled every time you call it, whilst a stored procedure compilation is cached so could execute faster?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts