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 26th March 2003, 00:34
makiju's Avatar
makiju makiju is offline
Senior Member
 
Join Date: Oct 2001
Location: Finland
Posts: 117
makiju is on a distinguished road
Baan: IVc4, LN6.1 - DB: Oracle, Informix - OS: all
More read performance ?

What method is best (or is there any...), if I want to read table tiitm001 by using several spindles at the same time? (think about bdbpre6.1 or full table scan, where rows are read one by one)
Let's say, I want separate fields to different tablespaces, which are in different disks in Oracle. How it's possible?

hpux11 BaanIV Oracle 8.1.6
Reply With Quote
Sponsored Links
  #2  
Old 26th March 2003, 17:42
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
Is hardware/software striping an option?
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
  #3  
Old 26th March 2003, 22:30
makiju's Avatar
makiju makiju is offline
Senior Member
 
Join Date: Oct 2001
Location: Finland
Posts: 117
makiju is on a distinguished road
Baan: IVc4, LN6.1 - DB: Oracle, Informix - OS: all
Theory first

I'm just thinking different possibilities. Let's start from an idea, that there is only a few very I/O-intensive tables like itm001, sls,pur and few big gld-tables. I'd like to start performance tuning from these tables and not going to stripe whole database with LVM extent based striping (hpux mirrordisk).
I have read tens of documents during few last days about striping and I'm still not sure is there any quarantee that read performance will get any better. Of course it helps with I/O balancing, but my goal is to get more read performace compared to mirrored pair (SC10).
Reply With Quote
  #4  
Old 27th March 2003, 06:20
JamesV JamesV is offline
Senior Member
 
Join Date: Aug 2001
Location: Grand Rapids, MI, USA
Posts: 225
JamesV is on a distinguished road
Baan: Baan IV/5 - DB: Oracle 7/8/8i,Informix, SQL Server, UDB - OS: AIX, HP-UX, Tru64, Solaris, NT/2000
It is fairly straightforward to place discrete tables on their own tablespace to avoid contention or to better balance IO.

The SC10 is not the best performing disk option out there so if you can stripe the IO using software RAID 0+1 and then use a degree of parallelism by increasing the number of IO slaves or async IO, then you will definitely get improved performance.

LVM manual striping (or chunking) is the manual placement of blocks by selectly using lvextend with explicit disk selection. This can improve IO, but is inconsistent when compared to the previous method.

-- Jim
__________________
Jim VanderMey
VP of Technical Operations
Open Systems Technologies
Grand Rapids, Michigan, USA
jvandermey@ostusa.com
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
Use of performance boosters - errors... r_nagu Tools Administration & Installation 17 17th August 2004 18:24
program that read tfgld106 is very slow therese Tools Development 3 19th November 2003 12:50
Performance Indicator itconsultant DEM & Workflow 2 22nd October 2002 06:44


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


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