Bug 270151 - chart designer performance issues
Summary: chart designer performance issues
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 2.3.2   Edit
Hardware: Macintosh Mac OS X - Carbon (unsup.)
: P3 normal (vote)
Target Milestone: 2.5.0 M7   Edit
Assignee: Heng Li CLA
QA Contact:
URL:
Whiteboard:
Keywords: performance
Depends on:
Blocks:
 
Reported: 2009-03-26 13:05 EDT by joel sherriff CLA
Modified: 2009-03-30 02:19 EDT (History)
2 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description joel sherriff CLA 2009-03-26 13:05:21 EDT
The chart designer seems to repeatedly connect to the datasource when making changes to a chart.  Not sure if it's just connecting, actually running queries, or "just" getting the query metadata.  If link speed or the remote database is slow, it's intolerable.  Doesn't make sense that the connection is being exercised when it is - for example, opening the color palette to change the color on a chart item.  I can imagine once at the beginning of the chart editing session, but it seems to happen for almost all changes to the chart.
Happens even when just going from one Edit Chart tab to another.

Evidence of the connection being used is the error:

Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
There is an error in get connection, Io exception: The Network Adapter could not establish the connection.

Which occurs if the connection is unavailable while editing the chart.

Most of my charts depend on joint datasets - perhaps this is related.
Comment 1 Yulin Wang CLA 2009-03-26 23:01:36 EDT
If your data set connecting is too slow, please disable chart live preview in chart builder via preference dialog.
Since 2.5M7 build, data preview in chart builder will be disabled by default. Please try it with latest build.
Comment 2 Yulin Wang CLA 2009-03-26 23:35:13 EDT
Just realize when "show data preview" is turned off, chart builder still preview data in tooltips.
Reopen it for enhancement change. 
Comment 3 Yulin Wang CLA 2009-03-26 23:39:23 EDT
The expected behavior should be able to enable/disable live data in chart builder via preference.
If "Enable live preview" is turned off in preference dialog, and "show data preview" is turned off as well, should NOT display live data in TOOLTIPS.
If "show data preview" is turned on, still show live data in table as before.
Comment 4 Heng Li CLA 2009-03-30 02:19:10 EDT
For the designer performance issue, if the 'enable live preview' is unchecked and there is no 'show data preview' mode, the preview data will not be retrieved.