Hi

Currently we are facing big problem of performance. Our setup is as follows
Baan IV c4
Informix 7.3 UD1
Porting Set 6.1c.07.03

Many of the queries executed in baan are taking long time compared to the same query getting executed at informix level.

e.g. Query on tfgld100 and tfgld101 using session tfgld1101m000
In Baan it takes - 10 min.
At informix level - 30 seconds

I am not sure whether porting set is adding any overhead or some other factor.

The parameter settings in db_resource, onconfig looks perfectly fine.

Please help out

Regards