ColdFusion Question:
What are the advantages and disadvantages of using stored procedures versus calling SQL inline in Cold Fusion?
Answer:
Stored procedures abstract database logic from server side code. They also offer performance benefits in pushing application logic to the database side.
The disadvantage is that if they are poorly written then they can hinder database performance and make development a little more obfuscated.
The disadvantage is that if they are poorly written then they can hinder database performance and make development a little more obfuscated.
| Previous Question | Next Question |
| How can you clear the cache? | How would you write a simple stored procedure in TSQL which takes a movie_id and returns all the directors associated with it? |