Ad-hoc Reporting: Slow CommonDomainDataStrategy

[wofrank]

Hello,

I am evaluating Jasper Business Intelligence Suite 3.7.

The ad-hoc report is in some cases quite slow. The reason is, that a filter value has in my test about 50.000 possible entries. In my example the processing (and logging) stops for about three minutes. Debugging shows me, that the method getFieldValues(String, int, Expression) in class CommonDomainDataStrategy (no source code because of evaluation) is the problem.
This method uses an ArrayList to collect the data. The method calls "contains" and "add" if the entry isn't avaliable. Perhaps it is possible to use a set instead of the list.
Is there another/better DomainDataStrategy which can be used for this scenario?

Kind regard

Wolfgang

[papanii]

 Hi Wolfgang, 

                       You are correct, we can improve the performance a bit by using a set. However, i am not sure if this change will fix your problem. I am going to do some profiling. I will keep you posted.

 

--Papanii

[papanii]

 Hi Wolfgang,

                       Firstly, let me say thank you for you suggestion. It seems we missed this during our earlier performance testing. We have fixed the issue and it will be added to our next patch release.  I will have someone contact you shortly.

--Papanii