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 3rd February 2003, 16:10
Erik Konrath Erik Konrath is offline
Member
 
Join Date: Nov 2001
Location: Cork (Ireland
Posts: 32
Erik Konrath is on a distinguished road
Baan: BaaNIVc4 -
Performance problems in session "Update Purchase Statistics"

Hi,

We would like to implement the purchase statistics module (our environment is BaaNIVc4 / DB is Oracle 4.0).

The problem we encountered is that the session "Update Purchase Statistics" is running a very long time and it creates huge temp files. We had to kill the session after 48 hours...

Do you know how we could improve the performance of this session? I received a patch from BaaN Support to improve the performance, but I'm rather sceptical that it will work...

Any hints would be greatly appreciated.

Thanks & Regards,

Erik
Reply With Quote
  #2  
Old 3rd February 2003, 21:52
EdwinvdBorg EdwinvdBorg is offline
Guru
 
Join Date: Aug 2001
Location: Netherlands
Posts: 514
EdwinvdBorg is on a distinguished road
Baan: 2.2, 3.1, b40, b50, b51, ERP LN FP3, ERP LN FP7, ERP LN 10.2.1 - DB: ALL - OS: ALL
Request latest object compiled in profile mode

Hi Erik,

Please request the latest object of the session compiled in profile mode from BAAN Support.
It is important to allow the session to run completely. The output should give BAAN Support enough info what is happening here.

Are you really running Oracle 4.0?

Regards,

Edwin
Reply With Quote
  #3  
Old 12th February 2003, 11:14
Martin Martin is offline
Senior Member
 
Join Date: Aug 2001
Location: Germany
Posts: 135
Martin is on a distinguished road
Baan: IVc, ERP5c - DB: oracle 9i, 10g, 11g - OS: Windows, HP-UX, SLES8/9/10/11
I love this session !

In Baan Standard, if you start the update sales statistics, a lot of statistic-tables would be deleted, row by row ! (very nice).

I had created a small baan program, which delete the tables with db.clear.table.

Then create a job, first session is delete the baan tables, then run the sessions for update sales statistics.


Martin
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
Purchase Statistics Performance problems Erik Konrath Distribution, Transportation & Warehousing 1 4th February 2003 07:19
Performance problem in session tisfc0102m000 christophe Manufacturing & Supply Chain 5 29th January 2003 16:59
Traceability of Purchase Invoices after running Process Delivered Purchase Orders Neal Matthews Finance, Invoicing and Integration 15 27th November 2001 12:12
tfacp9450m000 FIBU Brush Up Kai's Forum Users Deutsches Forum 1 16th November 1999 00:00
Herstellkostenberechnung in BaaN 4c Kai's Forum Users Deutsches Forum 4 5th July 1999 00:00


All times are GMT +2. The time now is 10:43.


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