Summary

ColdFusion works with most common database formats, and, for those not directly supported, it can instead work with exported data in the form of text files. When working with databases, ColdFusion functions as a gateway program, using a system's ODBC capabilities to create an open pipeline in and out of a database.

Good database design is crucial in optimizing the performance of ColdFusion applications, and a well-planned database will save coding time in building templates. It's important to create a visual representation of a database before you actually sit down at the computer to identify tables, fields, input, and data relationships.

Sharing data across tables saves input time and helps keep things organized. It's also important ...

Get Sams Teach Yourself ColdFusion® in 21 Days now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.