• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 48. Improving Performance > Using Bind Parameters

Using Bind Parameters

Most databases provide a mechanism to bind SQL parameters to specific datatypes. Doing so prevents the database (and database drivers) from having to perform implicit type conversions. The major benefits of parameter binding are:

  • Improved performance

  • Support for large columns

  • From a ColdFusion perspective, preventing hacking via URL parameter manipulation


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint