View Single Post
  #1  
Old 22nd November 2016, 09:52
richard richard is offline
Senior Member
 
Join Date: Oct 2001
Location: France
Posts: 178
richard is on a distinguished road
Baan: triton 3.2/Baan IV/LN - DB: Oracle 9.2.0.6/informix 31 - OS: HP UX 11.23
Performance refers to
Baan: ERP LN 6.1 FP8 (Infor ERP 10.2)
DB: SQL Server 2012
OS: Windows 7
C/S: None/Unknown

Hello,
We have performance issues in ticprdll2001 (in ticpr2210), top/down.
When I replace the "refers to" by a simple equal of fields (between tcibd001 and tiipd001/tcibd200), the performance is much better.
Is there a parameter in db_resource to set?
Out db_resource is quite short:
msql_opt_rows:5
msql_array_fetch:1
msql_array_insert:1
msql_max_arrsz:5
mle_join_type:

Regards
Reply With Quote