Macromedia provides a well-written explanation of how ColdFusion MX 6.1 deals with database connections. The topics covered include an explanation of what happens when ColdFusion processes CFQUERY tags and what it means to maintain database connections.
How are Database Connections Handled in ColdFusion?