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 30th January 2003, 18:29
grzegorz grzegorz is offline
Senior Member
 
Join Date: Sep 2001
Location: Zabrze, Poland
Posts: 155
grzegorz is on a distinguished road
Baan: BaaN IV c4, Baan5c, ERP LN (at last) - DB: Tbase, Oracle - OS: SCO, SUSE, AIX. W2K3
Strange tbase performance

Hello,

maybe someone will be able to help me with that:

I have two different servers, "powerfull" live serwer IBM RS6000 and "poor" test server , Intel based Compaq with SCO Unix for some developing works ; both with BaaN Base

On the test server we have developed some new sessions, dealing with new tables in a new module, and everything is running fast. But, after import DD on live server the same sessions (even on the same data) are running very slow.
I have obserwed, that problem lies in fetch time of first row in select statements. For instance I have following select

select tkikd068.* from tkikd068 for update
where tkikd068.year inrange :year.f and :year.t
selectdo ...etc , where year is third part of four-part index.
Table has about 2000000 records, 500000 of them is matching criteria.
On test environment first row is selected after 0.17 seconds. On live environmet we must wait minutes for first row to be fetched.

What can be wrong?
__________________
Best regards
Grzegorz .
Reply With Quote
  #2  
Old 30th January 2003, 19:55
Han Brinkman's Avatar
Han Brinkman Han Brinkman is offline
Guru
 
Join Date: Aug 2001
Location: The Netherlands
Posts: 1,155
Han Brinkman has a spectacular aura aboutHan Brinkman has a spectacular aura about
Baan: All - DB: Oracle/ms-sql/db2 - OS: *nix/windows
Maybe

the reason could be the jfs of AIX. Do you actually notice during the fetch of the first row a lot of I/O on the disk particular on the transaction part of the volume group?

It's already a few year back that I have worked with AIX, but due to the transaction principle of jfs working with tbase/bisam is not that fast.

But the difference is too much.

Hope you get more response.

Rgrds,
Han
Reply With Quote
  #3  
Old 3rd February 2003, 09:44
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: The Netherlands
Posts: 1,072
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 - DB: MS SQL2008 - OS: VM WindowsServer2008R2
healthy indices

Are your index files clean? If there were a lot of delete/inserts on the tables: reorganize and test again.
__________________
Also read Luke 24:4-8
Reply With Quote
  #4  
Old 3rd February 2003, 10:33
grzegorz grzegorz is offline
Senior Member
 
Join Date: Sep 2001
Location: Zabrze, Poland
Posts: 155
grzegorz is on a distinguished road
Baan: BaaN IV c4, Baan5c, ERP LN (at last) - DB: Tbase, Oracle - OS: SCO, SUSE, AIX. W2K3
It was my first idea. Already done, did not help.
__________________
Best regards
Grzegorz .
Reply With Quote
  #5  
Old 3rd February 2003, 11:48
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: The Netherlands
Posts: 1,072
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 - DB: MS SQL2008 - OS: VM WindowsServer2008R2
Does it change when you use the between qualifier instead of inrange? And if you make it two different where clauses, > year.f and <= year.t?
__________________
Also read Luke 24:4-8
Reply With Quote
Sponsored Links
  #6  
Old 3rd February 2003, 12:01
grzegorz grzegorz is offline
Senior Member
 
Join Date: Sep 2001
Location: Zabrze, Poland
Posts: 155
grzegorz is on a distinguished road
Baan: BaaN IV c4, Baan5c, ERP LN (at last) - DB: Tbase, Oracle - OS: SCO, SUSE, AIX. W2K3
Hello,

a query I posted is just an example - the problem is that every update session runs much slower than we expected - and there are lots of different quieries in those sessions. We use indices and write our componens according to official Performance Guide. So i think the problem is not in non optimized queries.
Do you know about any tbase parameter that can make all select statements to be treated like "as prepared set" (first row fetched after whole query processing) ?
__________________
Best regards
Grzegorz .
Reply With Quote
  #7  
Old 3rd February 2003, 12:18
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: The Netherlands
Posts: 1,072
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 - DB: MS SQL2008 - OS: VM WindowsServer2008R2
I assume both boxes run tbase...
Is there a difference in parameter settings? $BSE/lib/tbase/*param
__________________
Also read Luke 24:4-8
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 16:10
Use of performance boosters - errors... r_nagu Tools Administration & Installation 17 17th August 2004 17:24
Performance Indicator itconsultant DEM & Workflow 2 22nd October 2002 05:44


All times are GMT +2. The time now is 00:14.


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