|
Re: Performance problem in paging through the report with large data set [message #368649 is a reply to message #368640] |
Wed, 17 June 2009 13:54 |
Eclipse User |
|
|
|
Originally posted by: jasonweathersby.windstream.net
Indu,
Can you post the report?
Jason
Indu wrote:
> Hi
>
> We are facing a rigorous performance problem in a report, which
> comprises a large dataset. There are about 9 million data in the
> oracle database. And we tried pulling up 2000 claim data out of it.
> The report being pulled up, but it takes around 2.5 minutes to navigate
> to the next page through the report. The dataset of the report is
> comparitively large as it fetches lot many columns joined with multiple
> tables.
> Any idea, why is it very slow to page through the report data with large
> data set? Any suggested workaround for this?
>
> Thanks in advance.
>
|
|
|
|
Re: Performance problem in paging through the report with large data set [message #368685 is a reply to message #368664] |
Thu, 18 June 2009 19:31 |
Eclipse User |
|
|
|
Originally posted by: jasonweathersby.windstream.net
Indu,
Is the performance impact on the page controls or just generating the
report? You have quite a few nested lists which causes performance
impact, but should have little impact on rendering any specific page.
BTW any change you could try with 2.3?
Jason
Indu wrote:
> Jason,
>
> I have posted the report content below. This report has been connected
> to mylocal oracle database (not connected to the sample db) and the main
> query is contained in the dataset.
> ---------
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.2.1.r22a_v20071101 Build <2.2.1.v20071101-1439></property>
> <property name="units">in</property>
> <method
> name="initialize"><![CDATA[setEnterpriseId(reportContext,params);
> ROW_NUM = 0;]]></method>
> <property name="theme">ices_PE_library.iCESTheme</property>
> <text-property name="displayName">Edit Error By Provider</text-property>
> <list-property name="libraries">
> <structure>
> <property name="fileName">ices_PE_library.rptlibrary</property>
> <property name="namespace">ices_PE_library</property>
> </structure>
> </list-property>
> <list-property name="includeScripts">
> <property>query_functions.js</property>
> </list-property>
> <list-property name="configVars">
> <structure>
> <property name="name">CURRENT_DATE</property>
> <property name="value">01/01/70</property>
> </structure>
> <structure>
> <property name="name">PROCEDURE_CODES</property>
> <property name="value">no proc codes</property>
> </structure>
> </list-property>
> <parameters>
> <parameter-group name="Header" id="10002222044430145">
> <text-property name="displayName">Note: The more specific
> your search criteria is, the faster your report will run.</text-property>
> </parameter-group>
> <parameter-group name="Claim ID:" id="10004444406730">
> <text-property name="displayName">Claim ID:</text-property>
> <parameters>
> <scalar-parameter name="CLAIM_ID_START" id="10004444406731">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">From</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue"></property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="CLAIM_ID_END" id="10004444406732">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">To</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue"></property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> </parameters>
> </parameter-group>
> <parameter-group name="Import Date" id="10004444406733">
> <text-property name="displayName">Import Date:</text-property>
> <parameters>
> <scalar-parameter name="IMPORT_DATE_START"
> id="10004444406734">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">From (Enter in the
> format MM/DD/YYYY)</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue"></property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="IMPORT_DATE_END"
> id="10004444406735">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">To (Enter in the
> format MM/DD/YYYY)</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue"></property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> </parameters>
> </parameter-group>
> <parameter-group name="Service Date" id="10004444406736">
> <text-property name="displayName">Service Date:</text-property>
> <parameters>
> <scalar-parameter name="DATE_OF_SERVICE_START"
> id="10004444406737">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">From (Enter in the
> format MM/DD/YYYY)</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue"></property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="DATE_OF_SERVICE_END"
> id="10004444406738">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">To (Enter in the
> format MM/DD/YYYY)</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue"></property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> </parameters>
> </parameter-group>
> <parameter-group name="Batch ID" id="10004444406739">
> <text-property name="displayName">Batch ID:</text-property>
> <parameters>
> <scalar-parameter name="BATCH_ID_START" id="10004444406740">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">From</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue"></property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="BATCH_ID_END" id="10004444406741">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">To</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue"></property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> </parameters>
> </parameter-group>
> <parameter-group name="Provider" id="10004444406742">
> <text-property name="displayName">Provider ID:</text-property>
> <parameters>
> <scalar-parameter name="PROVIDER_ID_START"
> id="10004444406743">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">From</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue"></property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="PROVIDER_ID_END"
> id="10004444406744">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">To</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue"></property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> </parameters>
> </parameter-group>
> <parameter-group name="Patient" id="10004444406745">
> <text-property name="displayName">Patient ID:</text-property>
> <parameters>
> <scalar-parameter name="PATIENT_ID_START"
> id="10004444406746">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">From</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue"></property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="PATIENT_ID_END" id="10004444406747">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">To</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue"></property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> </parameters>
> </parameter-group>
> <parameter-group name="Additional Data" id="10004444406748">
> <text-property name="displayName">Additional
> Data</text-property>
> <parameters>
> <scalar-parameter name="CLAIM_STATUS"
> id="10002222044430226">
> <property name="valueType">dynamic</property>
> <property name="dataType">string</property>
> <property name="paramType">multi-value</property>
> <text-property name="promptText">Claim
> Statuses</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">list-box</property>
> <property name="dataSetName">ErrorLevelData
> Set</property>
> <expression
> name="valueExpr">dataSetRow["ANALYSIS_STATUS"]</expression >
> <property name="mustMatch">true</property>
> <property name="fixedOrder">true</property>
> <property name="defaultValue">[ALL]</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="FLAG_TYPES" id="11">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">multi-value</property>
> <text-property name="promptText">Flag
> Status</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">list-box</property>
> <property name="mustMatch">true</property>
> <property name="fixedOrder">true</property>
> <property name="defaultValue">R</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> <property name="pattern">Unformatted</property>
> </structure>
> <list-property name="selectionList">
> <structure>
> <property name="value">P</property>
> <property name="label">Profile</property>
> </structure>
> <structure>
> <property name="value">R</property>
> <property name="label">Review</property>
> </structure>
> <structure>
> <property name="value">D</property>
> <property name="label">Deny</property>
> </structure>
> <structure>
> <property name="value">I</property>
> <property name="label">Interim</property>
> </structure>
> </list-property>
> </scalar-parameter>
> <scalar-parameter name="CONTEXT" id="10002222044430106">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property
> name="promptText">Environment</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">radio-button</property>
> <property name="fixedOrder">true</property>
> <property name="defaultValue">1</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> <list-property name="selectionList">
> <structure>
> <property name="value">1</property>
> <property name="label">Live</property>
> </structure>
> <structure>
> <property name="value">0</property>
> <property name="label">Test</property>
> </structure>
> </list-property>
> </scalar-parameter>
> <scalar-parameter name="MOST_RECENT_ANALYSIS" id="13">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">Analysis
> Type</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">radio-button</property>
> <property name="fixedOrder">true</property>
> <property name="defaultValue">Most Recent</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> <property name="pattern">Unformatted</property>
> </structure>
> <list-property name="selectionList">
> <structure>
> <property name="value">Most Recent</property>
> <property name="label">Most Recent
> Analysis</property>
> </structure>
> <structure>
> <property name="value">First Time</property>
> <property name="label">First Time
> Analysis</property>
> </structure>
> </list-property>
> </scalar-parameter>
> <scalar-parameter name="GROUP_BY" id="20">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">Group
> By</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">radio-button</property>
> <property name="fixedOrder">true</property>
> <property name="defaultValue">Claim</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> <property name="pattern">Unformatted</property>
> </structure>
> <list-property name="selectionList">
> <structure>
> <property name="value">Claim</property>
> <property name="label">Claim</property>
> </structure>
> <structure>
> <property name="value">Provider</property>
> <property name="label">Provider</property>
> </structure>
> <structure>
> <property name="value">Patient</property>
> <property name="label">Patient</property>
> </structure>
> <structure>
> <property name="value">Plan</property>
> <property name="label">Plan</property>
> </structure>
> <structure>
> <property name="value">Account</property>
> <property name="label">Account</property>
> </structure>
> </list-property>
> </scalar-parameter>
> <scalar-parameter name="ACCOUNTS" id="10002222044430221">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property
> name="promptText">Accounts</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">[ALL]</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="PLANS" id="10002222044430222">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">Plans</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">[ALL]</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="FLAGS" id="10002222044430223">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">Flags</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">[ALL]</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="USERS" id="10002222044430224">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">Users</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">[ALL]</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="PLACE_OF_SERVICE"
> id="10002222044430225">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">Places Of
> Service</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">[ALL]</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> </parameters>
> </parameter-group>
> <scalar-parameter name="CURRENT_DATE" id="8">
> <property name="hidden">true</property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">01/01/1970</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> <property name="pattern">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="CURRENT_TIME" id="9">
> <property name="hidden">true</property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">00:00:00.0</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> <property name="pattern">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="REQUESTER" id="10">
> <property name="hidden">true</property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">setup</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> <property name="pattern">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="PROVIDER_SPECIALTIES" id="26">
> <property name="hidden">true</property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">no specialties</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> <property name="pattern">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="DIAGNOSIS_CODES" id="28">
> <property name="hidden">true</property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">no diag codes</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> <property name="pattern">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="PROCEDURE_CODES" id="29">
> <property name="hidden">true</property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">no proc codes</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> <property name="pattern">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="Desc_CLID1" id="1000001370">
> <property name="hidden">true</property>
> <property name="valueType">static</property>
> <property name="dataType">integer</property>
> <property name="paramType">simple</property>
> <property name="concealValue">false</property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">1</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="ENTERPRISE_ID" id="10002222044430099">
> <property name="hidden">true</property>
> <property name="valueType">static</property>
> <property name="dataType">integer</property>
> <property name="paramType">simple</property>
> <text-property name="promptText">Enterprise_Id</text-property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">5</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="source" id="10002222044430124">
> <property name="hidden">true</property>
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">ICES</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> </parameters>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
> id="3">
> <property
> name="odaDriverClass">oracle.jdbc.driver.OracleDriver</property >
> <property
> name="odaURL">jdbc:oracle:thin:@localhost:1521:freyaSID</property >
> <property name="odaUser">freya</property>
> <encrypted-property name="odaPassword"
> encryptionID="base64">bWlkZ2FyZDE=</encrypted-property>
> <property name="odaJndiName">java:/apollo-datasource</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="EditError Data Set" id="42">
> <list-property name="columnHints">
> <structure>
> <property
> name="columnName">SUBMITTED_CLAIM_IID</property>
> <property
> name="displayName">SUBMITTED_CLAIM_IID</property>
> </structure>
> <structure>
> <property name="columnName">PROVDS_CLAIM_IID</property>
> <property name="displayName">PROVDS_CLAIM_IID</property>
> </structure>
> <structure>
> <property name="columnName">LINE_EID</property>
> <property name="displayName">LINE_EID</property>
> </structure>
> <structure>
> <property
> name="columnName">PROVDS_CLAIM_LINE_IID</property>
> <property
> name="displayName">PROVDS_CLAIM_LINE_IID</property>
> </structure>
> <structure>
> <property name="columnName">CLAIM_ID</property>
> <property name="displayName">CLAIM_ID</property>
> </structure>
> <structure>
> <property name="columnName">PATIENT_ID</property>
> <property name="displayName">PATIENT_ID</property>
> </structure>
> <structure>
> <property name="columnName">PATIENT_DOB</property>
> <property name="displayName">PATIENT_DOB</property>
> </structure>
> <structure>
> <property name="columnName">BATCH</property>
> <property name="displayName">BATCH</property>
> </structure>
> <structure>
> <property name="columnName">CLAIM_STATUS</property>
> <property name="displayName">CLAIM_STATUS</property>
> </structure>
> <structure>
> <property name="columnName">ACCOUNT_ID</property>
> <property name="displayName">ACCOUNT_ID</property>
> </structure>
> <structure>
> <property name="columnName">ACCOUNT</property>
> <property name="displayName">ACCOUNT</property>
> </structure>
> <structure>
> <property name="columnName">GENDER</property>
> <property name="displayName">GENDER</property>
> </structure>
> <structure>
> <property name="columnName">ENTERPRISE</property>
> <property name="displayName">ENTERPRISE</property>
> </structure>
> <structure>
> <property name="columnName">PLAN_ID</property>
> <property name="displayName">PLAN_ID</property>
> </structure>
> <structure>
> <property name="columnName">PLAN_NAME</property>
> <property name="displayName">PLAN_NAME</property>
> </structure>
> <structure>
> <property name="columnName">IMPORT_DATE</property>
> <property name="displayName">IMPORT_DATE</property>
> </structure>
> <structure>
> <property name="columnName">ENVIRONMENT</property>
> <property name="displayName">ENVIRONMENT</property>
> </structure>
> <structure>
> <property name="columnName">BEGIN_DOS</property>
> <property name="displayName">BEGIN_DOS</property>
> </structure>
> <structure>
> <property name="columnName">END_DOS</property>
> <property name="displayName">END_DOS</property>
> </structure>
> <structure>
> <property name="columnName">ADJ_PROC_CODE</property>
> <property name="displayName">ADJ_PROC_CODE</property>
> </structure>
> <structure>
> <property name="columnName">MODIFIER_CODE</property>
> <property name="displayName">MODIFIER_CODE</property>
> </structure>
> <structure>
> <property name="columnName">DIAGNOSIS_CODE</property>
> <property name="displayName">DIAGNOSIS_CODE</property>
> </structure>
> <structure>
> <property name="columnName">UNITS</property>
> <property name="displayName">UNITS</property>
> </structure>
> <structure>
> <property name="columnName">POS</property>
> <property name="displayName">POS</property>
> </structure>
> <structure>
> <property name="columnName">TOS</property>
> <property name="displayName">TOS</property>
> </structure>
> <structure>
> <property name="columnName">REVENUE_CODE</property>
> <property name="displayName">REVENUE_CODE</property>
> </structure>
> <structure>
> <property name="columnName">PROVIDER_ID</property>
> <property name="displayName">PROVIDER_ID</property>
> </structure>
> <structure>
> <property name="columnName">PROVIDER_FNAME</property>
> <property name="displayName">PROVIDER_FNAME</property>
> </structure>
> <structure>
> <property name="columnName">PROVIDER_LNAME</property>
> <property name="displayName">PROVIDER_LNAME</property>
> </structure>
> <structure>
> <property name="columnName">SUB_CHARGE</property>
> <property name="displayName">SUB_CHARGE</property>
> </structure>
> <structure>
> <property name="columnName">ADJ_CHARGE</property>
> <property name="displayName">ADJ_CHARGE</property>
> </structure>
> <structure>
> <property name="columnName">CLAIM_LINE_SEQ</property>
> <property name="displayName">CLAIM_LINE_SEQ</property>
> </structure>
> <structure>
> <property name="columnName">DISPOSITION</property>
> <property name="displayName">DISPOSITION</property>
> </structure>
> <structure>
> <property name="columnName">MODEL_LINE_ID</property>
> <property name="displayName">MODEL_LINE_ID</property>
> </structure>
> <structure>
> <property name="columnName">FLAG_INDICATOR</property>
> <property name="displayName">FLAG_INDICATOR</property>
> </structure>
> <structure>
> <property name="columnName">MNEMONIC_LINEID</property>
> <property name="displayName">MNEMONIC_LINEID</property>
> </structure>
> <structure>
> <property name="columnName">EDIT_MNEMONIC</property>
> <property name="displayName">EDIT_MNEMONIC</property>
> </structure>
> <structure>
> <property name="columnName">EDIT_DESCRIPTION</property>
> <property name="displayName">EDIT_DESCRIPTION</property>
> </structure>
> <structure>
> <property name="columnName">FLAG_STATUS</property>
> <property name="displayName">FLAG_STATUS</property>
> </structure>
> <structure>
> <property
> name="columnName">MODIFIED_FROM_CLAIM</property>
> <property
> name="displayName">MODIFIED_FROM_CLAIM</property>
> </structure>
> <structure>
> <property
> name="columnName">MODIFIED_FROM_CLAIM_LINE</property>
> <property
> name="displayName">MODIFIED_FROM_CLAIM_LINE</property>
> </structure>
> <structure>
> <property name="columnName">RULESET_NAME</property>
> <property name="displayName">RULESET_NAME</property>
> </structure>
> <structure>
> <property name="columnName">TOTAL_SUB_CHARGE</property>
> <property name="displayName">TOTAL_SUB_CHARGE</property>
> </structure>
> <structure>
> <property name="columnName">TOTAL_ADJ_CHARGE</property>
> <property name="displayName">TOTAL_ADJ_CHARGE</property>
> </structure>
> <structure>
> <property name="columnName">IS_MODIFIED_UDF</property>
> <property name="displayName">IS_MODIFIED_UDF</property>
> </structure>
> <structure>
> <property name="columnName">UDF_LINE_ID</property>
> <property name="displayName">UDF_LINE_ID</property>
> </structure>
> <structure>
> <property name="columnName">UDF1_VALUE</property>
> <property name="displayName">UDF1_VALUE</property>
> </structure>
> <structure>
> <property name="columnName">UDF2_VALUE</property>
> <property name="displayName">UDF2_VALUE</property>
> </structure>
> <structure>
> <property name="columnName">UDF3_VALUE</property>
> <property name="displayName">UDF3_VALUE</property>
> </structure>
> <structure>
> <property name="columnName">UDF4_VALUE</property>
> <property name="displayName">UDF4_VALUE</property>
> </structure>
> <structure>
> <property name="columnName">UDF5_VALUE</property>
> <property name="displayName">UDF5_VALUE</property>
> </structure>
> <structure>
> <property name="columnName">UDF6_VALUE</property>
> <property name="displayName">UDF6_VALUE</property>
> </structure>
> <structure>
> <property name="columnName">UDF7_VALUE</prope
|
|
|
|
Re: Performance problem in paging through the report with large data set [message #368703 is a reply to message #368699] |
Fri, 19 June 2009 14:34 |
Eclipse User |
|
|
|
Originally posted by: jasonweathersby.windstream.net
Indu,
I have never seen a page navigation take that long. Is there any chance
you could try the report with the 2.5 RC4 build? Also it would be good
to log a bug so we can track the issue.
Jason
Indu wrote:
> Hi Jason,
>
> There was an impact on the performance of report generation too. But
> later, the query was optimized to some extent. Now the issue is all
> about the page navigation interval duration. It is reported like, it
> takes around "2.5 minutes" to move through the pages after the report
> has been generated when there were about 9 million claim data in the
> database.
> Is this duration acceptable? In the design i have posted, all the lists
> possess a page break interval of 200. Does reducing this page break
> interval improves the performance?
>
> Currently, the product is released with the reports being developed in
> BIRT 2.2.1. As of now we have not come up with any decision to upgrade
> to 2.3. Will this be fixed in 2.3? Or any workaround to handle this now?
> Please help.
>
> Thanks.
>
|
|
|
|
Powered by
FUDForum. Page generated in 0.04055 seconds