What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
- 1 Answers
- 1302 Views
- I also Faced
- E-Mail Answers
Answer Posted / Sachin Vishnoi
Advantages of using stored procedures:
1. Improved Performance: Stored procedures can be compiled and optimized by the database engine before execution.
2. Security: They help protect sensitive SQL code from unauthorized users.
3. Reduced Network Traffic: Since the procedure is stored on the server, only the results need to be sent over the network.nnDisadvantages:
1. Inflexibility: Once a stored procedure is created and deployed, it can't be easily changed or updated.
2. Learning Curve: Mastering stored procedures requires understanding of SQL and the specific database system being used.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain how to generate iqd file from framework manager?
What is the purpose of Dataware Control?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
