Re: Optimizing a BaaN installation

Jaime Casanova wrote: > Hi, > > i'm just starting in an enterprise that has BaaN IV c with the > following specifications: > > Server: > 3 RAID5 (with 4 disks each one) > 4 processors > 4Gb Ram You've had a lot of suggestions on this thread, unfortunately mostly Informix centric, and thus, for Baan's level 1 driver, mostly useless. The level 1 driver is from their flat file days, and as such they calculate hash keys for every record and select 1 record at a time. So there are no joins, no temp space (much) and hence usual tactics like query optimisation and distributions don't work. Also, it is best to use Baan's own utilities for moving tables around, otherwise you could end up corrupting their hash keys. The 2 main things that will help your performance are, get rid of RAID5 in favour of RAID1 or 10, and distribute your tables across many dbspaces based on IO. I have done this in the past and seen a good improvement in performance. A 3rd option would be to upgrade to the level 2 driver if you can. If you are going to get a consultant in, make sure they know BaaN/Informix, cos an Informix consultant could make things worse very quickly. ;-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ -- Internal Virus Database is out-of-date. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.3/171 - Release Date: 15/11/2005 sending to informix-list