⟩ What are the advantages and disadvantages of using stored procedures versus calling SQL inline in Cold Fusion?
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.