Bug 207124 - Enhance filter performance.
Summary: Enhance filter performance.
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 2.2.0   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: Future   Edit
Assignee: Mingxia Wu CLA
QA Contact:
URL:
Whiteboard:
Keywords: performance, plan
Depends on:
Blocks:
 
Reported: 2007-10-23 03:42 EDT by Lin Zhu CLA
Modified: 2010-03-30 01:36 EDT (History)
4 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Lin Zhu CLA 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 CLA 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 CLA 2007-11-12 01:13:38 EST
We need some additional time to fix this. Defer to M4.
Comment 3 Lin Zhu CLA 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 CLA 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.