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

Chapter 48. Improving Performance > Eliminating Unnecessary Database Access

Eliminating Unnecessary Database Access

Database access (and waiting for databases) is the single biggest bottleneck in ColdFusion applications. As such, ColdFusion developers invest (or should invest) a significant amount of time into improving database access time (and even eliminating it when possible). There are lots of things that can negatively impact database performance:

  • Poor database and table design

  • Nonrelational tables

  • Incorrect data types used

  • Poorly written SQL

  • Lack of indexes

  • Not using stored procedures

  • … and much more


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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