Stored Procedure or Views?

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Stored Procedure or Views?

    Hi All,
    I am using SQL-Server for my Coldfusion application, In performane base, which is better, SP or Views?
    Comments invited.
    Thanks in advance
    CFDYN
    cfdyn Guest

  2. Similar Questions and Discussions

    1. stored procedure help
      Hi all! I am in need of writing a few stored procedures. The first one is to create a stored procedure to recover a database from backup and the...
    2. Using a stored procedure
      I am trying to pass a ProdID to a stored procedure, but I get an error: Error Executing Database Query. Procedure 'PriceBreak' expects...
    3. Stored procedure?
      Stored procedure ?? -- Message posted via http://www.dotnetmonster.com
    4. is it possible 2 create views, triggers & stored procedures in Access?
      speaking of me, I'm not very new to Access, but I haven't worked on it as a professional. I know that you can fire queries in Access, but I don't...
    5. create views from parameterized stored procedures
      I'm looking to do as the topic says, I currently use temporary real tables (not #temp tables) that i keep in existence for just long enough for an...
  3. #2

    Default Re: Stored Procedure or Views?

    Having a well designed database including indexes where you need them is a lot
    more significant than anything you are asking. Also, stored procedures and
    views are not mutually exclusive.

    Originally posted by: cfdyn
    Hi All,
    I am using SQL-Server for my Coldfusion application, In performane base,
    which is better, SP or Views?
    Comments invited.
    Thanks in advance
    CFDYN



    Dan Bracuk Guest

Posting Permissions

  • You may not post new threads
  • You may 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