
Contents > Developing ColdFusion MX Applications > Using Query of Queries > About Query of Queries > Benefits of Query of Queries

Benefits of Query of Queries

Performing a Query of Queries has many benefits, including the following:

If you need to access the same tables multiple times, you greatly reduce access time, because the data is already in memory (in the record set).
A Query of Queries is ideal for tables of 5,000 to 50,000 rows, and is limited only by the memory of the ColdFusion MX host computer.
You can perform joins and union operations on results from different data sources.
For example, you can perform a union operation on queries from different databases to eliminate duplicates for a mailing list.
You can efficiently manipulate cached query results in different ways. You can query a database once, and then use the results to generate several different summary tables.
For example, if you need to summarize the total salary by department, by skill, and by job, you can make one query to the database and use its results in three separate queries to generate the summaries.
You can obtain drill-down, master-detail information for which you do not access the database for the details.
For example, you can select information about departments and employees in a query, and cache the results. You can then display the employees' names. When users select an employee, the application displays the employee's details by selecting information from the cached query, without accessing the database.


Contents > Developing ColdFusion MX Applications > Using Query of Queries > About Query of Queries > Benefits of Query of Queries

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.

Current page: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/using_r7.htm