ColdFusion Interview Question:

What are the advantages and disadvantages of using stored procedures versus calling SQL inline in Cold Fusion?

Submitted by: Administrator

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.
Submitted by: Administrator