Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 164799

Summary:	Dataset querying N number of times if the dataset bind with N number of data items
Product:	z_Archived	Reporter:	lavakumar <lavakumar>
Component:	BIRT	Assignee:	Mingxia Wu <mwu>
Status:	RESOLVED DUPLICATE	QA Contact:
Severity:	normal
Priority:	P3	CC:	yliang
Version:	2.1.1
Target Milestone:	---
Hardware:	PC
OS:	Windows 2000
Whiteboard:

Description lavakumar

2006-11-16 06:58:59 EST

Hi, 

I have a dataset which will run across one millon lines. Through that I am getting N number of aggregate measures and I am showing across N number of places in Report. So, Now the dataset query result is not caching, but running N number of times against datasource and taking too much time. What I require is running the data set query only one time and cache the results and display across N number of places.

Thanks.



Please give solution, what I needs to configure.

Comment 1 Liang Yu

2006-11-19 21:09:07 EST

Please investigate this bug.

Thanks.

Comment 2 lavakumar

2006-11-20 00:26:48 EST

Please resolve this bug and make it as duplicate of  #164798 (https://bugs.eclipse.org/bugs/show_bug.cgi?id=164798).

But you can suggest any alternative rather than suggested in 164798 it would be great.

That is regarding, if same dataset query is associated with 50 data items in report, the datasetquery is executing 50 times against database. This will not I expect. Instead it has to execute only once and cache the resultset and show values respectively in 50 data items.

Thanks
Lava kumar.

Comment 3 Lin Zhu

2006-11-20 00:27:37 EST


*** This bug has been marked as a duplicate of 164798 ***