Hi,

When i execute some sessions the time for view result are many large. Only a few times. Not always.

What can i check?


:confused:

Hello,

Firstly, I would suspect the system load since the execution time is not contently latent.

Secondly, the network, if Baan and the DBMS are on separate systems. In this case you should profile the database driver.

Thirdly, the relevant session, if I has been customised. Perhaps there's a inefficient select statement.

There are probably some more possibilities, but you should perhaps start with these.


Good Luck

Originally posted by zacharyg

Secondly, the network, if Baan and the DBMS are on separate systems. In this case you should profile the database driver.


Hi zacharyg,

Please can you explain in detail what you mean by profile the database driver? Thanks.

Benito,

What's meant is that you can 'trace' or 'log' DBMS requests.

Rabbeneg, do not crosspost please.