performance issue in domain definition.

[juvenzh]

Domain report filter works in jasperserver instead of in DB , so there will be big memory and performance issue if the table has huge data.

When I create  domain and domain report. I expect the following: in the derived table. the query can use input parameter .

 when create derived table, i input some string like    select   id , name from tableA where id=$P{id} ,  $P{id} is the input parameter.  it doesn't work. So I can only do the following:

input select   id , name from tableA and when create domain report ,  input id=$P{id} in the filter,

this time it works,  from the MySQL log, i  see  select   id , name from tableA  that  mean all records in the table returned . and the filter happen in Jasperserver instead of in MySQL.  So it will cause performance issue.

 

Can I use parameter in domain definition to avoid performance issue?  or there is other solution?

 

Thanks in advance