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

suggessions are appriciable.

rgds
Sanjay

iBaanERP Tuning Guide (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=7665)

Fred

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.

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

· Consider dynamic SQL


Is dynamic SQL better/faster than embedded SQL?

Regards,
Nico

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