Professional Web Applications Themes

Stored Procedure vs. SQL Through Recordset. - Macromedia Dreamweaver

The advantage to using stored procedures are many. 1. Speed. Once a stored procedure is compiled SQL "remembers" it, executing it extremely fast from then on. Inline SQL statements is must be executed as a new query each time. 2. Ease of maintenance. If you have to change a query that is used by multiple pages you only need to go in and change one stored procedure instead of several web pages. 3. Security. Your call to the database is handled by SQL Server and not your web page, preventing someone that may see your code from getting your table ...

  1. #1

    Default Re: Stored Procedure vs. SQL Through Recordset.

    The advantage to using stored procedures are many.

    1. Speed. Once a stored procedure is compiled SQL "remembers" it, executing
    it extremely fast from then on. Inline SQL statements is must be executed as
    a new query each time.

    2. Ease of maintenance. If you have to change a query that is used by
    multiple pages you only need to go in and change one stored procedure
    instead of several web pages.

    3. Security. Your call to the database is handled by SQL Server and not your
    web page, preventing someone that may see your code from getting your table
    names and structure.

    I have not used Access databases for web pages, but a quick google search
    turned up this tutorial that may help you.
    [url]http://www.stardeveloper.com/articles/display.html?article=2001050101&page=1[/url]

    craig



    "Jordan Marton" <JMartonHAHAmarketaxess.com> wrote in message
    news:bejt9p$56e$1forums.macromedia.com...
    From what I've gathered, a stored procedure is a SQL statement STORED in the
    database as opposed to the ASP page correct? Are there any advantages to
    this? And does Accesshave stored proceudres?

    Jordan



    craig v Guest

  2. #2

    Default Re: Stored Procedure vs. SQL Through Recordset.

    That was absolutely brilliant!!!

    Jordan

    "craig v" <craig765spamless-> wrote in message
    news:bejvaj$973$1forums.macromedia.com...
    > The advantage to using stored procedures are many.
    >
    > 1. Speed. Once a stored procedure is compiled SQL "remembers" it,
    executing
    > it extremely fast from then on. Inline SQL statements is must be executed
    as
    > a new query each time.
    >
    > 2. Ease of maintenance. If you have to change a query that is used by
    > multiple pages you only need to go in and change one stored procedure
    > instead of several web pages.
    >
    > 3. Security. Your call to the database is handled by SQL Server and not
    your
    > web page, preventing someone that may see your code from getting your
    table
    > names and structure.
    >
    > I have not used Access databases for web pages, but a quick google search
    > turned up this tutorial that may help you.
    >
    [url]http://www.stardeveloper.com/articles/display.html?article=2001050101&page=1[/url]
    >
    > craig
    >
    >
    >
    > "Jordan Marton" <JMartonHAHAmarketaxess.com> wrote in message
    > news:bejt9p$56e$1forums.macromedia.com...
    > From what I've gathered, a stored procedure is a SQL statement STORED in
    the
    > database as opposed to the ASP page correct? Are there any advantages to
    > this? And does Accesshave stored proceudres?
    >
    > Jordan
    >
    >
    >

    Jordan Marton Guest

Similar Threads

  1. Stored Procedure
    By Aaron Bertrand - MVP in forum ASP.NET
    Replies: 13
    Last Post: July 5th, 05:43 AM
  2. Using a stored procedure
    By MarkWright in forum Coldfusion Database Access
    Replies: 13
    Last Post: April 15th, 05:53 PM
  3. Help - stored procedure not returning a recordset
    By Bill S. in forum ASP Database
    Replies: 5
    Last Post: February 13th, 10:06 AM
  4. Suppressing second recordset from stored procedure
    By A_X_L_V in forum ASP Database
    Replies: 5
    Last Post: November 6th, 09:54 PM
  5. Help with Stored Procedure returning recordset
    By Ivar in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 2nd, 04:31 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139