Baanboard.com

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

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 7th May 2003, 01:58
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
Index Parts Info

Suhas asked me this good question about the Index parts info.

This info might be useful for everyone.

From the Known limits - BaaN ERP Programmers Guide

Tables
maximum record length is 3072 bytes
maximum number of fields is 1024
maximum field length is 3072 bytes
maximum number of indices per table is 31
Indexes
maximum index length is 120 bytes
maximum number of fields is 32 (no combined fields)
maximum number of index parts is 8
(This indicates the switch between different data types is limited to 8).

BaanERP Application Software Engineering Guides
Index restrictions


Problem
It is quite unknown why there are restrictions on an index.

A restriction on the number of physical index parts in one index
Problem
The maximum number of physical index parts is 8. The number of logical index parts can be more.
Under certain circumstances the Baan 4GL tools can combine logical index parts into physical index parts.
These index parts will only be combined when:
- the index field parts are of type STRING, BYTE, SET or ENUM.
- these index parts are physically stored straight after each other. (the field number is one lower or one higher).
Example

A restriction on the physical length of an index
In the BaanERP programmers guide, the maximum size of an index has been set to 120 bytes. This is a safety limit.
The real limit is the size of 255 bytes. But this is a physical limit.
The reason of the existance of this difference is because the level 1 driver uses internally hash columns.
These hash columns need some more physical space and are also limited in size.
The physical index length can be calculated by next formulae:
X = A * 1 + B * 3 + C * 5 + D * ( E + F + 2 ) / 2 + G * H + I * H * 2

where:
A = Number of index field parts of type BYTE
B = Number of index field parts of type INTEGER
C = Number of index field parts of type LONG, DATE
D = Number of index field parts of type FLOAT, DOUBLE
E = Number of digits before floating point
F = Number of digits after floating point
G = Number of index field parts of type STRING
H = String length
I = Number of index field parts of type MULTI BYTE
__________________
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
Sponsored Links
  #2  
Old 7th May 2003, 06:35
learner's Avatar
learner learner is offline
Guru
 
Join Date: Dec 2002
Location: New zealand
Posts: 562
learner is on a distinguished road
Baan: BaaN Vc with sp 28 - DB: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit - OS: HP-UX B.11.31
nice information !!

thanks for this nice piece of information, hope that u continue this trend in near future.
Reply With Quote
  #3  
Old 8th May 2003, 07:06
suhas-mahajan's Avatar
suhas-mahajan suhas-mahajan is offline
Guru
 
Join Date: Jan 2003
Location: Pune
Posts: 458
suhas-mahajan is an unknown quantity at this point
Baan: IV C4 IN3, IN5, IS5, LN - DB: Oracle 8.0.5, 9i, Informix - OS: Win NT, 2K, 2K3, AIX
Thanks!

Dear Sir,

Thanks for publishing important information. And I am sure, this is usefull for everyone.
I am trying to fit my values in the given formulae. Hope I get success soon.

Thanks Again.

-Suhas
Reply With Quote
  #4  
Old 21st June 2004, 21:01
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:
The maximum number of physical index parts is 8.
Updates with the latest tools patches -
Quote:
Limitation on 8 index parts
Author G Wal Creation Date: 17 May 2004 Alternate ID:
Solution No: 143821 Last Modified: 26 May 2004 Status: Published
Product: tt7.1a Sub Product: Session: ttadv5210m000
Package: tt Version: B50 Release: c
Symptom information
Too many index parts

Solution description
TOOLS VERSION(S):
7.1_a, 7.3_a

SITUATION IDENTIFIED IN:
"Convert to Runtime DD" (ttadv5215m000)

SITUATION DESCRIPTION:
For table definitions there is a limitation on number of index parts. This limitation is 8 and should be enlarged. While the limit of 8 index parts was because of Bisam.

SOLUTION DESCRIPTION:
The max number of index parts is now increased to 16.
Solution Type:
__________________
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
  #5  
Old 23rd June 2004, 09:07
suhas-mahajan's Avatar
suhas-mahajan suhas-mahajan is offline
Guru
 
Join Date: Jan 2003
Location: Pune
Posts: 458
suhas-mahajan is an unknown quantity at this point
Baan: IV C4 IN3, IN5, IS5, LN - DB: Oracle 8.0.5, 9i, Informix - OS: Win NT, 2K, 2K3, AIX
Hi

Thanks for the updates.

Regards,

-Suhas
Reply With Quote
  #6  
Old 4th July 2006, 10:52
mpenno's Avatar
mpenno mpenno is offline
Member
 
Join Date: Feb 2002
Location: Italy - Turin
Posts: 49
mpenno is on a distinguished road
Baan: BaanIV / BaanERP / LN - DB: Bisam / Oracle / SQLServer - OS: Aix / Sun / HP / Linux / Windows
Smile Index Parts Info

There is a solution for baanIVc4 ?

Thanks.

MP

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
Background info for bshell options (BaanIV) victor_cleto Tools Administration & Installation 61 26th January 2010 18:17
Problem with Porting Set 7.1c.03 for BaanERP 5.0b on Sun Solaris 5.0b baaniac Tools Administration & Installation 11 5th November 2003 07:23
Limit of Index parts baanbab Tools Development 3 19th August 2002 14:35
How to prevent passing of hints generated by Oracle Driver ? baaniac Performance & Tuning 6 24th May 2002 11:16


All times are GMT +2. The time now is 05:40.


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