Databases Reference
In-Depth Information
select link, label, value
from table
The link column stands for the URL you can navigate to when you click the label, the label is the text
that goes with the bar, the value is the numeric column that defines the bar size, and the table is the
table or view you want to query from.
The Result
We created two HTML charts on top of the
DEMO_PRODUCTS
table. The result looks like Figure 2-2. On the
left is a vertical HTML chart with all available attributes selected, and on the right is a horizontal HTML
chart with minimal attributes selected.
Figure 2-2.
HTML chart result
Debugging and Performance
Running a page with HTML charts is very fast and there is almost no overhead generating the chart. The
time that is necessary to render the page is completely linked to the query. Looking at the debug output
in Figure 2-3, you can see that timing is negligible.
Figure 2-3.
Debug output of a page with two HTML charts as in Figure 2-2
