Rob Brooks-Bilson (Team Macromedia) -- cont’dhttp://web.oreilly.com/news/coldfusion_0701.html
Lock all reads/writes of application, session, and server variables.
Avoid redirection with CFLOCATION when setting cookies.
Use stored procedures for database queries whenever possible.
- They are faster because the query code is precompiled.
- They support reuse across multiple platforms/applications.
- They can be more secure.
- They can employ richer functionality than a normal query.