Improvement of performance for the dynamic table

Hi, I am generating a dynamic table using the following script.
But it takes too long. Please suggest something to improve the performance. 
I think it is due to adding of individual cell in the for loop. Unfortunately org.eclipse.birt.report.model.api.SlotHanle class does not have addall() method. Is there an alternative?
 
function preQueryDataSet(dataSetName) { 
 var resultIterator; 
 var queryResult; 
 var dataReq; 
 try { 
 
 var dataSourceName = reportContext.getDesignHandle().findDataSet(dataSetName).getDataSourceName(); //Get DataSource Name from DataSet 
 
 importPackage(Packages.java.io); 
 importClass(org.eclipse.birt.data.engine.api.querydefn.QueryDefinition); 
 importClass(org.eclipse.birt.report.data.adapter.api.DataRequestSession); 
 importClass(org.eclipse.birt.report.data.adapter.api.DataSessionContext); 
 // Run preQuery data set 
 var myconfig = reportContext.getReportRunnable().getReportEngine().getConfig(); //Get report engine configurations 
 var dataSource = reportContext.getDesignHandle().findDataSource(dataSourceName); //Get DataSource handle for "DATA_SOURCE_NAME" 
 var dataSet = reportContext.getDesignHandle().findDataSet(dataSetName); //Get DataSet handle for "DATA_SET_NAME" 
 var scriptCtx = _jsContext.getScriptContext(); //Get JavaScript context 
 var ctx = new DataSessionContext(DataSessionContext.MODE_DIRECT_PRESENTATION, reportContext.getDesignHandle(), scriptCtx, null); //Get DataSession context 
 dataReq = DataRequestSession.newSession(myconfig, ctx); //Get DataRequestSessionImpl (handle/object?) 
 var modelAdapter = dataReq.getModelAdaptor(); //Get DataModelAdapter (handle/object?) 
 var odaDataSource = modelAdapter.adaptDataSource(dataSource); //Get OdaDataSourceAdapter (handle/object?) 
 var odaDataSet = modelAdapter.adaptDataSet(dataSet); //Get OdaDataSetAdapter (handle/object?) 
 
 odaDataSet.setDataSource(dataSourceName); //Set DataSource to "DATA_SOURCE_NAME" 
 dataReq.defineDataSource(odaDataSource); 
 dataReq.defineDataSet(odaDataSet); 
 
 var queryDefinition = new QueryDefinition(); 
 queryDefinition.setAutoBinding(true); 
 queryDefinition.setDataSetName(odaDataSet.getName()); 
 var pq = dataReq.prepare(queryDefinition); 
 queryResult = pq.execute(null); 
 resultIterator = queryResult.getResultIterator(); 
 dataSetLogic(resultIterator); //Pass resultIterator to DataSetLogic function. 
 } 
 finally { 
 //Close up 
 if (resultIterator != null) { 
 java.util.logging.Logger.getLogger("birt.report.logger").info("resultIterator.close()"); 
 resultIterator.close(); 
 } 
 if (queryResult != null) { 
 java.util.logging.Logger.getLogger("birt.report.logger").info("queryResult.close()"); 
 queryResult.close(); 
 } 
 if (dataReq != null) { 
 java.util.logging.Logger.getLogger("birt.report.logger").info("dataReq.shutdown()"); 
 dataReq.shutdown(); 
 } 
 } 
} 
function dataSetLogic(resultIterator) { 
 var cc = resultIterator.getResultMetaData().getColumnCount(); //Get column count 
 var rsmd = resultIterator.getResultMetaData(); //Get metadata handle. 
 importPackage(Packages.org.eclipse.birt.report.model.api); 
 //get a reference to the ElementFactory 
 var elementFactory = reportContext.getReportRunnable().designHandle.getElementFactory(); 
 //create a new table element 
 var rptTable = elementFactory.newTableItem("rptTable", 0, 1, 0, 0); //(java.lang.String name, int columnNum, int headerRow, int detailRow, int footerRow) 
 rptTable.setWidth("100%"); //Set table width 
 reportContext.getReportRunnable().designHandle.getBody().add(rptTable); //Add table element to report body 
 for (var i = 0; i < cc; i++) { 
 rptTable.insertColumn(i, 1); 
 var label = elementFactory.newLabel("Label"); //create label 
 label.setText(rsmd.getColumnName(i + 1)); //set label text 
 var tableCell = rptTable.getHeader().get(0).getCells().get(i); //get table cell 
 tableCell.getContent().add(label); //add label to table cell 
 } 
 var rowNumber = -1; //Start counter with -1 so first 
 while (resultIterator.next()) { //Loop through each row in the entire Data Set (iResultIterator) 
 rowNumber++; //add row number 
 rptTable.insertRow(new RowOperationParameters(2, -1, rowNumber)); //insert row 
 for (var i = 0; i < cc; i++) { //Loop through each column in the row. 
 var label = elementFactory.newLabel("Label"); //create label element 
 label.setText(resultIterator.getValue(rsmd.getColumnName(i + 1))); //set "Name" text. *Note: Add 1 as column's start with 1 rather than 0 
 var tableCell = rptTable.getDetail().get(rowNumber).getCells().get(i); //get table cell 
 tableCell.getContent().add(label); //add label to cell 
 } 
 } 
} 
//

Thanks for the suggstions.

Find more posts tagged with

Comments

There are no comments yet