Go Back > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 54

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 29th November 2011, 10:14
fschew fschew is offline
Join Date: Oct 2011
Posts: 1
fschew is on a distinguished road
Baan: V - DB: DB2 - OS: AIX
Session tisfc0101m100 is very slow


Access to the most recent record is almost immediate, but it can take up to 20 minutes to access an older record (say,about 20 records away from the most recent record). Once in the session if we use the left arrow on the menu bar to go to the previous record, it will takes a long time, whereas using the right arrow key to go the the next record will be very fast.

We don't have much data as we only started to use it since the beginning of the year. We are using FP3 running on oracle database. We have reorganized tables tisfc010, tirou001, tirou002, tirou003 and tisfc001.

Any feed back is much appreciated.

Thanks and regards
Reply With Quote
Old 29th November 2011, 17:30
mark_h's Avatar
mark_h mark_h is offline
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,219
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Did you rebuild the indexes and repair reference counters at the same time? That has helped us in the past and is the only suggestion I have.

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Old 29th November 2011, 22:40
Kozure Ohashi's Avatar
Kozure Ohashi Kozure Ohashi is offline
Join Date: Dec 2003
Location: Tokyo-Otsuka
Posts: 324
Kozure Ohashi is on a distinguished road
Baan: Baan IV c4 SP 19, ERP LN 6.1 FP3 - DB: 10g R2 - OS: Linux SLES 10 64 Bit

As far as I remember, baan will read the next n (20 or something) records in the buffer ...

So if you move to the next higher record it is already in the buffer and seems to be fast.

If you select an previous record, the querry will be executed once again ... which will take some time.

This was always a test for me checking the response time of the database and check if the statistics has to be updated.

But if you only have some data and running on oracle proper setting of your statistics should be checked ( we always set estimate statistics with 30 percentage).
To check if the oracle statistics are the reason you could switch the optimizer to rule based (not cost based) just for testing.
Another point could be setting proper values to max permutation (how many ways to the data should be checked before querrying ... we reduced this setting ... and get faster response).


Last edited by Kozure Ohashi : 29th November 2011 at 22:52.
Reply With Quote
Sponsored Links

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
Handling Unit functionality baazigar Distribution, Transportation & Warehousing 4 19th February 2012 16:54
zoom to correct business partner jojovalenton Tools Development 5 14th October 2009 11:26
Session Runs very slow sivasankari Tools Development 4 23rd June 2009 12:39
slow executing session mig28mx Tools Administration & Installation 24 28th October 2005 17:44
Start a customized session from a standard session ltannous Tools Development 15 26th May 2005 15:08

All times are GMT +2. The time now is 11:56.

©2001-2018 - -