Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
44%
Installation Wizard into new VRC
25%
Manual into existing VRC
6%
Manual into new VRC
25%
Total votes: 16

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #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
Sponsored Links
  #2  
Old 22nd November 2016, 21:19
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,026
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
I don't think there is a predefined parameter to replace the "refers to" by "=".

Refer to the following threads if they help you out -

Query Performance

Oracle 10 Question Looking for Suggestions
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Performance Tracing and Tuning Dikkie Dik Performance & Tuning 20 10th January 2013 16:10
performance dll Hitesh Shah Code & Utilities 11 2nd March 2009 13:29
How to create a select statement for the following ltannous Tools Development 8 1st March 2004 07:53
select statement in script option ltannous Tools Development 4 17th February 2004 20:37
report script problem ltannous Tools Development 15 8th November 2002 16:07


All times are GMT +2. The time now is 02:05.


©2001-2017 - Baanboard.com - Baanforums.com