Data Source Management
Tutorials and Articles
Query Caching in ColdFusion
Many projects start small with one ColdFusion web server and one database server. Then the
development team encounters one of two motivating factors the
need for more uptime (availability) or the need for more capacity (scalability). This article
discusses the latter, enhancing scalability through the use of query caching.
Simple Caching Techniques With CFsavecontent
If you've ever had to deal with dynamic web pages, you know that sometimes the results can take a while to process. Whether you use complex SQL queries or other techniques to get data out, actually generating the resulting page may be a slow process. ColdFusion has many tools that you can use to help find slow templates and make them quicker.
Server Caching in ColdFusion
This article explores server caching in ColdFusion, introducing its different pieces and providing examples of how server caching works and its benefits.
ColdFusion best practices for Oracle databases
This article explores integrating Oracle databases into your ColdFusion applications. Techniques unique to Oracle are examined from both a performance and development perspective. While Oracle is used as the example, some of the concepts apply to other database vendors' products as well.
CFQUERYPARAM and Oracle Databases
This document explores how the cfqueryparam tag works, specifically related to Oracle. Most other major relational databases, such as Microsoft SQL Server or Informix, also implement bind variables. Smaller desktop databases like Microsoft Access may not. Check with your database vendor, as well as the drivers, to see if bind variables are supported.
Programmatic Caching in ColdFusion
This article discusses CFML coding techniques you can use to cach p-code, perform page output caching, client-side caching, database query caching, and the use of the cachedwithin and cachedafter attributes of the cfquery tag.
TechNotes
- 2d2a7a19—ColdFusion MX 6.1 and 7: Connecting to MS Access using the jadoZoom JDBC driver
- 5444c687—ColdFusion MX 6.1: Creating a data source with isolation level READ_UNCOMMITTED
- 12ea2000—ColdFusion MX 7: Using the SequelLink Type 3 driver to connect to ODBC data sources
- 6ef0253—How to use MySQL 4.1 with ColdFusion MX
- tn_19612—Configuring an Oracle OCI data source for ColdFusion MX deployed on SunOne 7 Application Server
- tn_19607—ColdFusion MX: Creating a pure Java connection to a data source
- tn_19406—Behavior of cached queries when maximum number is set to 0
- tn_19375—ColdFusion MX data source configuration causes 'port out of range' error
- tn_19267—ColdFusion 5: Data source connection to Oracle 9.2 database fails
- tn_19217—ColdFusion MX issues with double byte data from ColdFusion 5 databases
- tn_19195—JTOpen JDBC driver hangs when a bad user name or password is sent to the database
- tn_19171—ColdFusion MX: Configuring the IBM Informix JDBC Driver
- tn_19170—ColdFusion MX: Configuring the MySQL JDBC driver (MySQL Connector)
- tn_19135—ColdFusion MX: Manually installing and uninstalling the ColdFusion MX ODBC services
- tn_18656—Dynamic data sources in ColdFusion MX
- tn_18652—ColdFusion MX: Configuring the Microsoft SQL Server 2000 JDBC driver
- tn_18649—ColdFusion MX: Data source verification fails for Oracle JDBC Thin Driver
- tn_18612—ColdFusion MX: Trailing space in Driver Class field causes data source verification failure
- tn_18593—ColdFusion MX support for JDBC drivers not shipped with ColdFusion
- tn_18591—ColdFusion MX: Configuring the Sybase jConnect 5.5 driver
- tn_18532—Reserved words for data source names in ColdFusion MX on Windows platforms
- tn_18520—ColdFusion MX support for Oracle OCI JDBC driver
- tn_18061—ColdFusion (All Versions): How are database connections handled in ColdFusion?
- tn_18050—Reserved words for various databases
- tn_18025—ColdFusion Server 5: Connecting ColdFusion on Windows NT to Informix 7 database
- tn_17980—ColdFusion 5: Dynamic ODBC connection with Oracle on WinNT and Win2000
- tn_17938—ColdFusion: Two methods for arrays and Oracle stored procedures
- tn_17660—Using cursors in Oracle stored procedures
- tn_17506—Configuring OLE DB Data Sources in ColdFusion
- tn_17034—Using Microsoft Access databases in a production environment
