We are running into performance issues while the adhoc report is being loaded. The adhoc view however is faster. These are the following configuration changes tried out: Swap File Virtualizer Heap Size of 10GB Compression of HTTP responses at tomcat audit.sizeof.enabled=false To generate a report on 173420 (checked by running the query on redshift) it takes close to 12 minutes. Is there anything we are doing wrong ? Jasperserver version : Product Version: 6.1Build: 20150527_1447 Product Edition: Professional for AWS