txarmel
7th October 2008, 12:52
Hi all,
we upgraded porting set(6.1c.07.20) and Tools SP (25) a few weeks ago, and we have noticed performance problems in some reports that used to work fine.
Debugging the problem we see that the program "freezes" in the select. As there are other reports that do the same query, we have tested them and they work fine.
The only difference in the session that "freezes" is that there is a group by sentence. We think this could be the problem.
As this report has worked fine for the last 5 years we think the problem is in our new BaaN installation.
Could it be on the db_resources file parameters?
we upgraded porting set(6.1c.07.20) and Tools SP (25) a few weeks ago, and we have noticed performance problems in some reports that used to work fine.
Debugging the problem we see that the program "freezes" in the select. As there are other reports that do the same query, we have tested them and they work fine.
The only difference in the session that "freezes" is that there is a group by sentence. We think this could be the problem.
As this report has worked fine for the last 5 years we think the problem is in our new BaaN installation.
Could it be on the db_resources file parameters?