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 6th December 2001, 23:47
jroberts's Avatar
jroberts jroberts is offline
Senior Member
 
Join Date: Nov 2001
Location: Guelph, Canada
Posts: 103
jroberts is on a distinguished road
Baan: Baan IVc4 SP5 - DB: Oracle 8.0.5 - OS: NT 4 SP 5
Performance Problem ~ Calculate Commissions

Baan IVc4 SP5, NT 4, Oracle 8.05
We are having serious performance problems with calculate commissions. It runs for about 22 - 25 hours every month. The setup is complex, with between three and five people getting commission on any sales order line, depending on the customer & item.

I did some testing on test server and found out that it was taking
about 15 minutes to calc for 100 sales orders (900 so lines).

So I enabled the 'display refresh = 180' and number of servers = 2 performance boosters, but that did not make a difference on the
run time.

When it is calculating, you can look at the task manager, and see the oracle 80 process sitting @ 100 % (of one processor).

Has anyone else had performance problems with calculate commissions ?
Suggestions on my next steps ?

John
Reply With Quote
  #2  
Old 7th December 2001, 15:23
JamesV JamesV is offline
Senior Member
 
Join Date: Aug 2001
Location: Grand Rapids, MI, USA
Posts: 225
JamesV is on a distinguished road
Baan: Baan IV/5 - DB: Oracle 7/8/8i,Informix, SQL Server, UDB - OS: AIX, HP-UX, Tru64, Solaris, NT/2000
John,

Quote:
We are having serious performance problems with calculate commissions. It runs for about 22 - 25 hours every month. The setup is complex, with between three and five people getting commission on any sales order line, depending on the customer & item.
This is one of the problem sessions in Baan. When you have a complex commission structure and you probably have a large number of sales order lines, the data volume involved results in large tables which causes query performance problems. Several of our customers have had mods done to this session to improve the commission calc process, or have offloaded the process to another program.

There is not a simple answer to this one. Sorry.

I would check on the support web site because I believe there are some performance related patches for this session. I do not know if they were already included in SP5.

Quote:
So I enabled the 'display refresh = 180' and number of servers = 2 performance boosters, but that did not make a difference on the
The display performance boosters will have little impact on a batch session like this one when running on a local LAN and if the process is spinning on an Oracle query issue.

I do not recall how the program uses multiple bshells. Many of the performance boosters were fixed in c4 and did not work in c2. Most of my customers were c2 or c4 soI do not know with c3.

Quote:
When it is calculating, you can look at the task manager, and see the oracle 80 process sitting @ 100 % (of one processor).
This is the key fact -- you probably have a query that is taking a long time to resolve. If you send me an email I can direct you to a tool that may help you to diagnose the individual query issue. I suspect that you have an indexing/table size related issue that is manifest with some poor queries or optimization (wrong hint, etc.) -- two problems working in conjunction to cause your performance issue.

I wish I had a simple answer for you on this one, but unfortunately, sometimes Baan queries are sub-optimal when run against large or complex datasets.

-- Jim
__________________
Jim VanderMey
VP of Technical Operations
Open Systems Technologies
Grand Rapids, Michigan, USA
jvandermey@ostusa.com
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
Sql Server Performance Problem santosh Tools Development 1 15th October 2003 15:00
serious performance problem GAURAVGUPTA9 Tools Administration & Installation 7 8th September 2003 19:55
Baan IVc2 and Oracle 8.1.7 performance problem mpenno Performance & Tuning 2 3rd September 2003 19:50
Performance problem in session tisfc0102m000 christophe Manufacturing & Supply Chain 5 29th January 2003 17:59


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


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