620
Chapter 28: Charting and Graphing Data
In this example, the data from the query column AvgByDept supplies the data for the y-axis, and
the query column Dept_Name provides the data for the x-axis.
The resulting chart looks like the following:
Administering charts
Use the ColdFusion MX Administrator to administer charts. In the Administrator, you can
choose to save cached charts in memory or to disk. You can also specify the number of charts to
cache, the number of charting threads, and the disk file for caching images to disk.
ColdFusion caches charts as they are created. In that way, repeated requests of the same chart load
the chart from the cache rather than having ColdFusion render the chart over and over again.
Note:
You do not have to perform any special coding to reference a cached chart. Whenever you use
the
cfchart
tag, ColdFusion inspects the cache to see if the chart has already been rendered. If so,
ColdFusion loads the chart from the cache.
The following table describes the settings for the ColdFusion charting and graphing engine:
Option
Description
Cache Type
Set the cache type. Charts can be cached in memory or to disk. Caching in
memory is faster, but more memory intensive.
Maximum number of
images in cache
Specify the maximum number of charts to store in the cache. When the limit
is reached, the oldest chart in the cache is deleted to make room for a new
one.
The maximum number of charts you can store in the cache is 250.
Max number of
charting threads
Specify the maximum number of chart requests that can be processed
concurrently. The minimum number is 1 and the maximum is 5. Higher
numbers are more memory intensive.
Disk cache location
When caching to disk, specify the directory in which to store the generated
charts.
Summary of Contents for COLDFUSION MX 61-DEVELOPING COLDFUSION MX
Page 1: ...Developing ColdFusion MX Applications...
Page 22: ...22 Contents...
Page 38: ......
Page 52: ...52 Chapter 2 Elements of CFML...
Page 162: ......
Page 218: ...218 Chapter 10 Writing and Calling User Defined Functions...
Page 250: ...250 Chapter 11 Building and Using ColdFusion Components...
Page 264: ...264 Chapter 12 Building Custom CFXAPI Tags...
Page 266: ......
Page 314: ...314 Chapter 14 Handling Errors...
Page 344: ...344 Chapter 15 Using Persistent Data and Locking...
Page 349: ...About user security 349...
Page 357: ...Security scenarios 357...
Page 370: ...370 Chapter 16 Securing Applications...
Page 388: ...388 Chapter 17 Developing Globalized Applications...
Page 408: ...408 Chapter 18 Debugging and Troubleshooting Applications...
Page 410: ......
Page 426: ...426 Chapter 19 Introduction to Databases and SQL...
Page 476: ...476 Chapter 22 Using Query of Queries...
Page 534: ...534 Chapter 24 Building a Search Interface...
Page 556: ...556 Chapter 25 Using Verity Search Expressions...
Page 558: ......
Page 582: ...582 Chapter 26 Retrieving and Formatting Data...
Page 668: ......
Page 734: ...734 Chapter 32 Using Web Services...
Page 760: ...760 Chapter 33 Integrating J2EE and Java Elements in CFML Applications...
Page 786: ...786 Chapter 34 Integrating COM and CORBA Objects in CFML Applications...
Page 788: ......