michelle_4 Posted September 29, 2015 Share Posted September 29, 2015 I have a query that requires temp tables. The tables need to be created, then indexed, then joined, and then finally I can select my final report data.When I do this in Jaspersoft Studio I get the error "No results were returned by the query"I tried writing the query with CTEs instead but the performance is unmanageable- taking over 15 minutes on some of my larger data sets where it takes less than 20 seconds for the same data sets with the temp, indexed tables.I'm running against a postgres database so the NOCOUNT ON trick isn't working either.I can see that this issue has been brought up quite a bit in the last few years- are there any good answers for this yet?Thanks Link to comment Share on other sites More sharing options...
christopher_5 Posted April 19, 2016 Share Posted April 19, 2016 2016, same problem here, any solution? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now