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
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 2nd September 2002, 13:25
pbarbosa's Avatar
pbarbosa pbarbosa is offline
Member
 
Join Date: Nov 2001
Location: Oporto (Portugal)
Posts: 70
pbarbosa is on a distinguished road
Baan: BaanIVc4 sch1 e Baan LN - DB: Sql Server 2008 - OS: Windows Server 2008 R2
Bad Performance

I have a very bad performance on session tisfc1101m000 "Maintain Production Planning".

I use BaanIVc4 Supply Chain and the tisfc010 is a Oracle 7.3 table

Regards
Paiva Barbosa
Reply With Quote
  #2  
Old 2nd September 2002, 14:10
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Guru
 
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,855
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
R u closing the orders

Hi,

You need to close the SFC orders regularly which deletes data from main table tisfc010.

Further if u can upgrade the oracle to 8.0 and porting set 6.1c.05.02 (we are working on this) , the problem may not come.

Is this specific to tisfc1101m000 only . Then installing latest patch/SP for this solution may be a good idea.

BTW How many records are there in tisfc010.
Reply With Quote
  #3  
Old 2nd September 2002, 15:22
pbarbosa's Avatar
pbarbosa pbarbosa is offline
Member
 
Join Date: Nov 2001
Location: Oporto (Portugal)
Posts: 70
pbarbosa is on a distinguished road
Baan: BaanIVc4 sch1 e Baan LN - DB: Sql Server 2008 - OS: Windows Server 2008 R2
Re: R u closing the orders

Quote:
Originally posted by Hitesh Shah
Hi,

You need to close the SFC orders regularly which deletes data from main table tisfc010.

Further if u can upgrade the oracle to 8.0 and porting set 6.1c.05.02 (we are working on this) , the problem may not come.

Is this specific to tisfc1101m000 only . Then installing latest patch/SP for this solution may be a good idea.

BTW How many records are there in tisfc010.
They have 7878 records.... is a small table.....
Reply With Quote
  #4  
Old 2nd September 2002, 15:28
Han Brinkman's Avatar
Han Brinkman Han Brinkman is offline
Guru
 
Join Date: Aug 2001
Location: The Netherlands
Posts: 1,155
Han Brinkman has a spectacular aura aboutHan Brinkman has a spectacular aura about
Baan: All - DB: Oracle/ms-sql/db2 - OS: *nix/windows
Trace

Try a trace with TT_SQL_TRACE=0200 to check if the session uses bad sql statements. This trace will give you the answer for that.

After this you probably have a hint where to look for.

Han
Reply With Quote
  #5  
Old 2nd September 2002, 17:04
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: The Netherlands
Posts: 1,072
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 - DB: MS SQL2008 - OS: VM WindowsServer2008R2
What is your patch level? Install latest solution 126049 first, so you can have a defect created if the problem still exists.
__________________
Also read Luke 24:4-8
Reply With Quote
Sponsored Links
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
bad performance - uploading texts in Exchange Eddy G Operating Systems & Databases 4 10th September 2004 11:38
Use of performance boosters - errors... r_nagu Tools Administration & Installation 17 17th August 2004 17:24
Error 509 (Bad memory cursor; bad table pointer) caodc1 Operating Systems & Databases 8 18th March 2003 11:00
Performance Indicator itconsultant DEM & Workflow 2 22nd October 2002 05:44


All times are GMT +2. The time now is 18:28.


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