Fill Factor in database used with baan
This is a discussion on Fill Factor in database used with baan within the Informix forums, part of the Database Server Software category; --> Hi all, OS: Windows NT Database: Informix IDS 9.2x ERP: BaaN B40c.66 checking for the onconfigs of the company ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 09:57 AM
| ||||
| ||||
 Fill Factor in database used with baan Hi all, OS: Windows NT Database: Informix IDS 9.2x ERP: BaaN B40c.66 checking for the onconfigs of the company i am working for... i have found that the two server are configured with FILLFACTOR 60... is this something BaaN is recommending are there any reasons for not having them in 90? any response will be appreciated... regards, Jaime Casanova systemguards at gmail dot com jaime.casanova at investamar dot com dot ec      |
|
04-20-2008, 10:02 AM
| |||
| |||
| Re: Fill Factor in database used with baan Hi, I've config. my FILLFACTOR 90 on both Baan5 and Baan4c for years without any problems. My OS is Solaris and IDS 9.21 upgraded IDS10. --Wayne Jaime Casanova wrote: > Hi all, > > > OS: Windows NT > Database: Informix IDS 9.2x > > ERP: BaaN B40c.66 > > checking for the onconfigs of the company i am working for... i have > found that the two server are configured with FILLFACTOR 60... is this > something BaaN is recommending are there any reasons for not having > them in 90? > > > any response will be appreciated... > > regards, > Jaime Casanova > > systemguards at gmail dot com > jaime.casanova at investamar dot com dot ec |
|
04-20-2008, 10:03 AM
| ||||
| ||||
| Re: Fill Factor in database used with baan Well if you are doing lots of inserts then having a lower fill factor reduces the need to add new index pages and restructure the nearby pages to link in the new page (page splits). See http://publib.boulder.ibm.com/infoce...oc/sqls211.htm |
Linear Mode
