Go Back > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 49

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 10th March 2005, 16:01
vyp_007 vyp_007 is offline
Junior Member
Join Date: Dec 2004
Location: India
Posts: 29
vyp_007 is on a distinguished road
Baan: Baan V - DB: Oracle - OS: HP UX
Performance Tuning

I have created a session, which extracts data from five different tables and inserts the same in a single table. What are the ways and means using which I can increase the speed of the session. At present the session is taking a lot of time to execute and produce results.

The table in which the extracted values are being inserted has only six fields.
Even then the performance is low. Please suggest me ways and means to increase the speed of the session.

Reply With Quote
Old 10th March 2005, 16:18
kbartelds kbartelds is offline
Senior Member
Join Date: Feb 2003
Location: Netherlands
Posts: 264
kbartelds is on a distinguished road
Baan: B40c4 - DB: Oracle 7 - OS: Sun Solaris
If you post your code, answers could be more accurate. In general, performance is hardly influenced by the number of field to fill. Usually performance problems will be caused by a wrong usage of index and order by combination in the query select statement, which might result in full table scans where sometimes only 1 record wil be retrieved.

Reply With Quote
Sponsored Links
Old 10th March 2005, 16:33
Francesco's Avatar
Francesco Francesco is offline
Join Date: Aug 2001
Location: Antwerp, BE
Posts: 727
Francesco is on a distinguished road
Baan: 5b - DB: Oracle - OS: Solaris
The basics

Hi Klaas,

Without getting in the specifics, this is my top 3 of things to do when your custom code runs slow.

1. Make sure you use the indexes of the five tables you query.
2. Make sure you use ONLY indexed fields in your queries.
3. Avoid full table scans and cartesian joins.


Admiral Business Solutions | My World | Baan Board | IT Happens!

"If everyone is thinking alike, then somebody isn't thinking" -- George Patton
"It's easy to cry 'bug' when the truth is that you've got a complex system and sometimes it takes a while to get all the components to co-exist peacefully." -- Doug Vargas
Reply With Quote

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
BaaN IV / SQL 2000 Performance tuning amolrp Operating Systems & Databases 2 27th August 2003 15:58
Oracle Performance Tuning Myths gguymer Performance & Tuning 2 18th May 2002 17:38

All times are GMT +2. The time now is 01:20.

©2001-2018 - -