$X{IN, <column_name>, <parameter_name>} very slow

[erik.dittert]

Hi,

i use $X{IN, <column_name>, <parameter_name>}$X{IN, <column_name>, <parameter_name>} in my querys. But its very slow (3-5 Minutes to generate a report).

when i changed it to:

where id in ($P!{list})[/code]

and use a parameter:

$P!{list} =  org.springframework.util.StringUtils.collectionToCommaDelimitedString($P{list_ids})

its much faster (10 seconds)

 

Did you know why?

 

Thx!