RE: Planning an Informix Database disk layout

In article <6vembs$qb1$1@news.xmission.com>, david.g.wilson@nz.eds.com (Wilson, David G) wrote: > > You're right. > > Informix version = 9.14UC2x6 > Platform = Sun - OS = Solaris 2.5.1 > Application - PowerBuilder development > > Disk Sizing could be up to 400+Gb - RAID 5 > > Some tables could have as many as 120,000,000 rows > > The hardware configuration essentially needs to be eliminated from the > picture, the question is trying to examine the Informix allocation of > chunks to DBSpaces. An article in Tech Notes, 6-1 begins to discuss > this, however it was largely about the hardware and disk connectivity. > The hardware configuration can not IMHO be eliminated as no matter how good the logical design of the database is, it will still run like a dog on poor hardware. Also you might like to consider Solaris 2.6 'cos it's quite a bit better, particularly with respect to memory handling and scaling when you add more processors ( ie the mutex control is much finer). There again you could wait for 2.7 which does fix a couple of the 'kernel can't add up' problems related to the various stats that are available. Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 # www.wfsoftware.co.uk