Linked report filters-changes 7.0 vs 7.4
I am currently reviewing moving from 7.0 build 20140730 to 7.4 build 20171204. I am testing the 7.4 build using the free version on AWS.
I have a particular report that ran fine on 7.0 but runs very slow/times out on 7.4. I call this report from other reports. It looks at a table that contains binary data, in this case images. I pass filter values to the report from the linking report.
It seems that the way the SQL is built for the report causes much more data to be pulled in 7.4, even with the same filters. I have attached SQL from the report on both systems-one showing the SQL generated in 7.4, the other in 7.0. It looks like 7.4 pulls the entire table into a new view, then filters from there.
I have also pulled each SQL statement out and ran directly against the DB. I can confirm the SQL generated by 7.4 takes much longer to run than that generated by 7.0.