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 29th November 2011, 09:14
fschew fschew is offline
Newbie
 
Join Date: Oct 2011
Posts: 1
fschew is on a distinguished road
Baan: V - DB: DB2 - OS: AIX
Session tisfc0101m100 is very slow

Hi,

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
FSChew
Reply With Quote
  #2  
Old 29th November 2011, 16:30
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,903
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.
__________________
Mark

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
  #3  
Old 29th November 2011, 21:40
Kozure Ohashi's Avatar
Kozure Ohashi Kozure Ohashi is offline
Guru
 
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
records

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).

http://www.baanboard.com/baanboard/s...ad.php?t=12254

Kozure

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


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


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