Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Administration & Installation

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 16th September 2008, 08:57
vineetu1's Avatar
vineetu1 vineetu1 is offline
Senior Member
 
Join Date: Jun 2002
Location: INDIA
Posts: 130
vineetu1 is on a distinguished road
Baan: BAAN C4 IN5 - DB: INFORMIX - OS: WINDOWS 2000
Split a large table
Baan: Baan IVc4
DB: Oracle 9.2.0.x
OS: Windows 2000
C/S: Both

Hi Guys,

Has any body ever split a table into multiple parts to improve performance ? How is it done and whether it is effective.

The Integration table has crossed 50,000,000 records, there are other such tables.

Checking whether we can avoid archiving ?
__________________
Vineet
Reply With Quote
  #2  
Old 16th September 2008, 09:55
sukesh75's Avatar
sukesh75 sukesh75 is offline
Guru
 
Join Date: Dec 2002
Posts: 1,031
sukesh75 is on a distinguished road
Baan: Baan 4c - DB: SQL Server 2000 - OS: Windows 2003
in addition to the above

Would also be interested in knowing if this sort of thing can be done with SQL Server as the back end??

Thnx
sk
Reply With Quote
  #3  
Old 16th September 2008, 18:36
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,028
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Quote:
Has any body ever split a table into multiple parts to improve performance ? How is it done and whether it is effective.
We have considered Oracle Partitioning and discussed but have not implemented it yet. More info @ Partitioning in Oracle
Quote:
The Integration table has crossed 50,000,000 records, there are other such tables.

Checking whether we can avoid archiving ?
Do you really need to save all those records? if not its better to purge them.
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
  #4  
Old 17th September 2008, 07:06
vineetu1's Avatar
vineetu1 vineetu1 is offline
Senior Member
 
Join Date: Jun 2002
Location: INDIA
Posts: 130
vineetu1 is on a distinguished road
Baan: BAAN C4 IN5 - DB: INFORMIX - OS: WINDOWS 2000
Splitting table

Is it Baan Application dependent or Database dependent ??
__________________
Vineet
Reply With Quote
  #5  
Old 22nd September 2008, 14:48
Nicholas's Avatar
Nicholas Nicholas is offline
Member
 
Join Date: Apr 2002
Posts: 30
Nicholas is on a distinguished road
Spliting tables...

This is what we are doing in Baan Vc in our inf_storage6.2 file. This might work for you.
tfgld106:180:T:group:0200:10:INITIAL 1800000 NEXT 180000 LOCK row [round robin in tfgld10601dbs, tfgld10602dbs, tfgld10603dbs]
tfgld106:180:I1:group:0200:10:DBSPACE tfxxxxxx04idx
tfgld106:180:I2:group:0200:10:DBSPACE tfxxxxxx05idx
tfgld106:180:I3:group:0200:10:DBSPACE tfxxxxxx06idx
tfgld106:180:I4:group:0200:10:DBSPACE tfxxxxxx07idx
tfgld106:180:I5:group:0200:10:DBSPACE tfxxxxxx08idx
tfgld106:180:I6:group:0200:10:DBSPACE tfxxxxxx01idx
tfgld106:180:I7:group:0200:10:DBSPACE tfxxxxxx02idx
tfgld106:180:I8:group:0200:10:DBSPACE tfxxxxxx03idx
Reply With Quote
  #6  
Old 23rd September 2008, 10:50
vineetu1's Avatar
vineetu1 vineetu1 is offline
Senior Member
 
Join Date: Jun 2002
Location: INDIA
Posts: 130
vineetu1 is on a distinguished road
Baan: BAAN C4 IN5 - DB: INFORMIX - OS: WINDOWS 2000
extents for Indexes

Hi Nicholas,

Were you using it the normal way and have later splitted the tables ? and has this improved the performance ??
__________________
Vineet
Reply With Quote
Sponsored Links
  #7  
Old 26th September 2008, 20:14
Nicholas's Avatar
Nicholas Nicholas is offline
Member
 
Join Date: Apr 2002
Posts: 30
Nicholas is on a distinguished road
Yes we were the "normal way", as in the tfgld106 table was only residing in a single dbspace. What happens with Round robin, is it writes record number 1 in the 1st dbspace, record number 2 in the 2nd dbspace and 3 record in the 3rd dbspace and so forth.

We try to keep a single dbspace & associated chunks on a single LUN, to assist with tracking where our performance hits are. We were originally 100% on IO. After we split this we dropped down to 33% on IO.

Hope that helps.
Reply With Quote
  #8  
Old 1st October 2008, 06:35
vineetu1's Avatar
vineetu1 vineetu1 is offline
Senior Member
 
Join Date: Jun 2002
Location: INDIA
Posts: 130
vineetu1 is on a distinguished road
Baan: BAAN C4 IN5 - DB: INFORMIX - OS: WINDOWS 2000
Io

Hi Nicholas,

How did u measure the IO activity for a specific table ? Could u tell me the command ?

I have the following queries :
1) how many records do you have in tfgld106.
2) Is it your largest table.
3) How many extents do you have for each of the three dbspace for tfgld106
4) For howmany tables have u done that ?
__________________
Vineet
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
Tables used for MRP and PRP. BurghMan Tools Development 1 10th February 2005 14:08
copy records c_siek Tools Development 9 18th June 2004 15:43
How to delete child table if the parent table has only 1 index with 3 fields? juhiasg Tools Development 4 12th February 2004 04:51
CODE: Table Loader ~Vamsi Code & Utilities 3 26th February 2003 13:05


All times are GMT +2. The time now is 13:35.


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