performance issue Studio vs. Report server

[glenarvand]

Hi,

I am using JasperSoft Reports 6.2.1 and when running a report within the Studio preview the output comes after 2 seconds.

Running the same report (output xlsx) on the server takes > half a minute - though there is no data volume issue (crosstab, 500 lines, 17 columns in excel,  "ignore pagination" = true).

I am using "$P{LoggedInUsername}" to filter data (based on the user's rights), run the report and realized, when using a fixed value (the user's id string) instead of the parameter in the query, the report execution speed is good.

Same against Oracle DB from SQL Developer - the query resultset with a user's id string is back in 2 sec.

Once switching back to the parameter in the query, the report takes ages again on the server and runs out of heap in the Studio.

Any ideas to share? Advices really appreciated!

 

Cheers,

Sebastian

[glenarvand]

Hi

Finally my problem was solved using the expression user_id = '$P!{LoggedInUsername}' instead of $P{LoggedInUsername} in the WHERE-part of my query.

Cheers,

Sebastian