Hi guys,
I was trying to improve Performance, by changing the program.

I tried to reduce the time taken by a select, by reducing the number of calls to the function(in which this select is present). After further analysis i found that , i got a big improvement in the select i targeted(as number of times the select is executed is reduced)

But the next select, on some other table started taking more time compared to earlier...

I observed this kind of problem, in 3 cases.

Does this points to some other problem ??


Thanks,
Rams

Hej,

this behaviour sounds very strange to me. Could you please add the source so we can have a detailled look why this is happening.

Cheers,

HI,
Intially, the program was taking longer time on select of tccom122.
I commented the select,as there is no use of that select for me..and Baan is not using this tccom122.rtyp, any more(they are using some other field instead of this).
After this i observed that more time is taken "tdint.dlltfacp.insert.update.order.line.data".
In this function also i removed some part of the code..and the next function is observed to be taking more time and so on...

select tccom122.rtyp |EURO
from tccom122
where tccom122._index1 = {:tdpur400.ifbp}
as set with 1 rows
endselect |EURO


if not tdint.dlltfacp.insert.update.order.line.data(tcmcs065.comp,
tfacp.otyp.purchase,
tdpur401.orno,
tdpur401.pono,
tdpur401.sqnb,
---------------------------------


Best Regards,
Ram