Some datasource settings are best suited for specific types of queries, while others might be better suited for other queries. For example, support for long text might be needed for some retrieval operations, but if used when not needed performance will suffer. For this reason it is often worthwhile to define multiple datasources for the same database – each with different settings – so that you may use the one that is best suited for any particular operation. (Applies to: ColdFusion All)

Leave a Reply