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 April 2003, 11:52
sanjayroongta sanjayroongta is offline
Member
 
Join Date: Apr 2002
Location: Delhi
Posts: 76
sanjayroongta is on a distinguished road
Baan: B40C4 - DB: Oracle - OS: Solaris 8
Application tunning guide

Is anybody have some BaaN IV application tunning guide or tips.

suggessions are appriciable.

rgds
Sanjay
Reply With Quote
  #2  
Old 4th April 2003, 01:05
fmorais's Avatar
fmorais fmorais is offline
Senior Member
 
Join Date: Mar 2002
Location: Portugal
Posts: 164
fmorais is on a distinguished road
Baan: B4c4 - DB: MSSQL, Oracle, Informix, BBase - OS: Windows, AIX
Did you check this thread?

iBaanERP Tuning Guide

Fred
__________________
The Sleeper has Awakened.
Reply With Quote
  #3  
Old 11th April 2003, 16:36
evertsen's Avatar
evertsen evertsen is offline
Guru
 
Join Date: Jun 2002
Location: Canada
Posts: 308
evertsen is on a distinguished road
Baan: IVc4 - DB: Oracle - OS: HP-UX
Most significant performance improvements when using Oracle are on the database side. A good DBA should be able to tweak Oracle to perform better with Baan.
__________________
Hope this helps,
Ev
Reply With Quote
  #4  
Old 15th April 2003, 15:45
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
Almost always the system runs better after:
- adding more and faster CPU's
- tune the database
- etc.

But when having a badly designed application, the biggest machine cries for mercy. There for desiging and writing code is at least of the same importance of tuning the environment. Internally there are some documents about application tuning wich I can't send (now) but hereby a performance checklist:

Baan 4GL Performance Checklist

Design
· Performance requirements should be documented
· Expected data volumes must be known before selecting an algorithm
· Estimate whether selected solution will meet requirements
· Use prototyping
· Keep open possibilities for parallel processing

Technical Realization
· Only calculate/query data you need
· Do not calculate/query data already known
· Cache static data that will be read multiple times
· Cache recurring calculations
· Only query tables that have a relation in one query
· Make relations on the index
· Avoid program logic in queries
· Consider query hints
· Consider dynamic SQL
· Be aware of cost of called functions
· Look at the order of arguments with OR and AND in if statements
· Make batch sessions restartable
· Transaction size not too large

Performance Improvement
· Measure! Use profile and BLAT
· Test with significant data volume
· Focus on most time consuming functions
· Focus on function and queries that are executed (too) often
· Verify improvements
· Repeat test with improved software

When having specific questions: You are welcome here!

Kind regards,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
  #5  
Old 28th May 2003, 14:49
NvanBeest's Avatar
NvanBeest NvanBeest is offline
Guru
 
Join Date: May 2003
Location: South Africa
Posts: 521
NvanBeest is on a distinguished road
Baan: BaanIVc4 - DB: Oracle, TBase, SQL Server - OS: AIX, Linux, Window$
Question

Quote:
· Consider dynamic SQL
Is dynamic SQL better/faster than embedded SQL?

Regards,
Nico
Reply With Quote
  #6  
Old 28th May 2003, 15:01
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
No, the perfomance of embedded SQL is the same as dynamic SQL when having the same query. But, sometimes dynamic SQL gives possibilities above embedded.

Hope this helps,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
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
SSA ERP-NL / Baan V6 is it Vaporware ? tjbyfield General Discussion & Chat 18 1st October 2004 10:50
Baan/Informix Tuning Guide baaniac Operating Systems & Databases 0 21st August 2003 13:23
application locks Baan-Anna Tools Administration & Installation 5 14th August 2003 00:18
Old but good stuff montanac Baan vs SAP, Peoplesoft, JDE, Oracle etc 0 15th April 2002 16:20


All times are GMT +2. The time now is 00:41.


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