An information object can be used as a data source in BIRT Studio. The information object’s query plan is compiled the first time a BIRT Studio user drags-and-drops a column from the Available Data pane to the report display area. If the information object is built from a large number of maps or information objects, the first drag-and-drop operation may take a long time. To avoid this problem, you can store a precompiled query plan with the information object.
Storing a precompiled query plan with an information object increases the size of the information object. For this reason, do not store a precompiled query plan with an information object unless the first drag-and-drop operation in BIRT Studio is unacceptably slow.
Store a precompiled query plan with an information object when either of the following conditions is true:
|
The information object is built from more than 100 tables consisting of more than 1000 columns.
|
If an information object query’s compile time is very large, it may be advisable to store a precompiled query plan with the information object.
A schematic representation of the query execution plan appears in the upper pane of Query Profiler, as well as Profiler Statistics such as compile time. In Figure 3-62, Profiler Statistics displays a compile time of three seconds.
|
Figure 3-62
|
