View Single Post
  #1  
Old 29th September 2010, 17:14
doornbos doornbos is offline
Junior Member
 
Join Date: Jun 2002
Location: The Netherlands
Posts: 27
doornbos is on a distinguished road
Baan: Baan IVc/ERPL LN - DB: Oracle - OS: AIX
How to trace SQL fetch times in ERP/LN
Baan: Other/Unknown
C/S: None/Unknown

Hello,

I've converted a report session from Baan4 to ERP/LN. But the session is very slow. So I would like to trace the sql fetch times to figure out what causes the delay. In Baan4 you can use TT_SQL_TRACE to trace fetch times of SQL queries. But in ERP/LN the trace output is very different and I can not see any fetch times. I use BAAN_SQL_TRACE=0200.

How do I trace the fetch times in ERP/LN?

Do you have any suggestions why the ERP/LN version of the session is so much slower (minutes in stead of seconds). I only modified sql/domains because of the database differences between Baan4 and ERP/LN.

With kindly regards,

Douwe.
Reply With Quote