View Single Post
  #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