Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
38%
Installation Wizard into new VRC
41%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 37

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 18th April 2007, 08:40
anubhav.bansal anubhav.bansal is offline
Junior Member
 
Join Date: Jun 2005
Posts: 23
anubhav.bansal is on a distinguished road
Baan: Baan IV - DB: Oracle - OS: Unix
Session tfgld5400m000 performance
Baan: Baan IVc4
DB: Oracle 8.0.3.x
OS: Solaris 8 (SunOS 5.8)
C/S: None/Unknown

Hi All,
This session performance is very slow,I have analyzed a bit on it's query and found out the following points:
1.If we remove { tfgld410.fyer, tfgld410.fprd } between
{ :fyer.f , :fprd.f } and {:fyer.t, :fprd.t} and selection on table tisfc001 then it makes the query very fast.
But we can not remove this otherwise query will be wrong from the functional point of view so can any one please suggest something on it.

Whole query which we are using is :

Code:
select tfgld410.ocom, tfgld410.tror, tfgld410.fitr, tfgld410.trdt,
tfgld410.trtm, tfgld410.sern, tfgld410.leac, tfgld410.orno,
tfgld410.dbcr, tfgld410.cprj, tfgld410.amth, tfgld410.pono,
tfgld410.tmpk
from tfgld410, tfgld418, tisfc001
where tfgld410._index2 inrange {:tfgld000.loco, "", tctror.prd, rno.f}
and {:tfgld000.loco, "", tctror.prd,rno.t}
and tfgld410.fcom = :fin.company
and { tfgld410.fyer, tfgld410.fprd } between
{ :fyer.f , :fprd.f } and {:fyer.t, :fprd.t}
and INV_WIP
| and tfgld410._index1 refers to tfgld418
and tfgld418._index1 = tfgld410.c001
and tfgld418.sint = tfgld.sint.posted
| and tfgld410.orno refers to tisfc001.pdno
and tisfc001._index1 = {tfgld410.orno}
and tisfc001.osta inrange sts.f and sts.t
order by tfgld410._index2
| as prepared set
Reply With Quote
Sponsored Links
  #2  
Old 18th April 2007, 15:59
Juergen's Avatar
Juergen Juergen is offline
Guru
 
Join Date: Aug 2001
Location: Germany
Posts: 567
Juergen is on a distinguished road
Baan: IVc4, ERP LN - DB: Oracle - OS: Linux, Unix
Hi,

is solution 162940 "The performance of the WIP reconciliation report is poor" installed on your system?

Regards,
Juergen
Reply With Quote
  #3  
Old 20th June 2007, 13:37
sushshah sushshah is offline
Junior Member
 
Join Date: Feb 2002
Posts: 4
sushshah is on a distinguished road
Baan: IV, ERP - DB: Oracle, Informix - OS: HP, Sun
Please try removing "as prepared set" statement.
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
synchronizing different occurrences on parent session from child Ruskin Tools Development 8 18th March 2008 18:56
Editable synchronized dialogue not started srinivas AFS/DDC/OLE: Function servers 10 21st July 2005 08:25
Performance problems in session "Update Purchase Statistics" Erik Konrath Performance & Tuning 2 12th February 2003 12:14
Performance problem in session tisfc0102m000 christophe Manufacturing & Supply Chain 5 29th January 2003 17:59


All times are GMT +2. The time now is 06:09.


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