| Contents > Developing ColdFusion MX Applications > Using Query of Queries > About Query of Queries > Benefits of Query of Queries |
|
|
|
|
||
Performing a Query of Queries has many benefits, including the following:
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.
For example, you can perform a union operation on queries from different databases to eliminate duplicates for a mailing list.
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.
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 |
|
|
ColdFusion 9 | ColdFusion 8 | ColdFusion MX 7 | ColdFusion MX 6.1 | ColdFusion MX | Forums | Developer Center | Bug Reporting
Version 6.1
Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.
Send me an e-mail when comments are added to this page | Comment Report
Current page: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/using_r7.htm