Bug 207124

Summary:	Enhance filter performance.
Product:	z_Archived	Reporter:	Lin Zhu <lzhu>
Component:	BIRT	Assignee:	Mingxia Wu <mwu>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	P3	CC:	rkanguri, wenfeng.fwd, xiang.li, xxue
Version:	2.2.0	Keywords:	performance, plan
Target Milestone:	Future
Hardware:	PC
OS:	Windows XP
Whiteboard:

Description Lin Zhu

2007-10-23 03:42:14 EDT

Currently we implement cube filter using Rhino. But in some cases we needn't have java script involved during filtering, say, the filter is against a level key or attribute. This bug intends to introduce new passway for cube filtering so that it can bypass Rhino to enhance performance.

Comment 1 xiaofeng zhang

2007-11-05 00:26:34 EST

A new method public void addSimpleLevelFilter( SimpleLevelFilter simpleLevelFilter ) is added in the interface ICubeQueryExcutorHelper. Disk index will be used to enhancement performance when executing these simple level filters.

Comment 2 Lin Zhu

2007-11-12 01:13:38 EST

We need some additional time to fix this. Defer to M4.

Comment 3 Lin Zhu

2007-12-17 22:33:53 EST

After investigation we found that unlike sort, the filter has to involve with rhino for not only the test expression but also the operand expressions are consists of javascript. We may seek for more specific filter optimization in future, say, by analysis the nature of filter expressions to see if rhino can be introduced in the filter preparation stage rather than execution stage to calculate the operands expression values. This however is a very big enhancement of filter support, which can also impact on tabular filter evaluation. Defer the bug to future and change the bug name.

Comment 4 Gary Xue

2008-12-22 13:55:17 EST

We plan to introduce structured filter in 2.5, where common filter conditions are no longer constructued as a Javascript expression. We will focus making structured filters as fast as possible. Deferring any performance enhancement related to Javascript expression filters to future.