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

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 49

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
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 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

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:

Reply With Quote
Sponsored Links
Old 22nd November 2016, 21:19
NPRao's Avatar
NPRao NPRao is offline
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,064
NPRao will become famous soon enough
Baan: Baan 4-5,5.2(Reger),LN-6.1,Infor LN-10.x - DB: Oracle,MS-SQL - OS: HPUX, 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

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 13:56.

©2001-2018 - -