Recently we upgraded from 12.10SR6 to 12.20SR6, and I notice that some of the apps took longer to load now.
For example, we have one script that aggregate the data from a 6GB qvd (6GB is before filtering. We filter the data. The loading time increased from 3mins to 7mins.
Any idea if there is change to the way aggregation works in 12.20SR6?
Sample script:-
LOAD
date([Posting Date]) as [Date],
sum(Amount*-1) as [Amount]
FROM
[Trans.QVD]
(qvd)
where [Company]='ABC'
and [Material]='XYZ'
and [Segment]='DEF'
group by
date([Posting Date]),
;
