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
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 10th March 2005, 17: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

Hi,
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.


Vishal
Reply With Quote
  #2  
Old 10th March 2005, 17: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.

Regards,
Klaas
Reply With Quote
Sponsored Links
  #3  
Old 10th March 2005, 17:33
Francesco's Avatar
Francesco Francesco is offline
Guru
 
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.
__________________
Cheers,

Francesco
..............................................................

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
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
Performance Tracing and Tuning Dikkie Dik Performance & Tuning 20 10th January 2013 17:10
BaaN IV / SQL 2000 Performance tuning amolrp Operating Systems & Databases 2 27th August 2003 16:58
Oracle Performance Tuning Myths gguymer Performance & Tuning 2 18th May 2002 18:38


All times are GMT +2. The time now is 12:29.


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