Re: Informix on NT or UNIX

Hofinger, Christian wrote: > > Hallo everyone, > > how are your experiences : Informix on NT versus Informix on UNIX. > > We are running Online 7.2 on UNIX, and the system is very slow. > Our configuratione looks as follows: > > ------------------------- > HP UX, 128 MB > > NFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 6 days 15:35:40 -- > 20336 Kbytes > ------------------------- > > There are batch processing every week. It was running for 10 hours. > Since last process > it needs more than 20 hours. > > What can be the reason for this increasing of time ?? > > Now, we are looking for a better system : Informix on NT ?? I seriously doubt that NT is the solution. Sounds like you need more resources for the database not a poorer, slower, less sophisticated operating system. How many CPUS? How fast? Is this a PA RISC or M68K HP system? Can you allocate more memory to Informix for buffers etc? How many disks do you have? What kind (SCSI I, SCSI II, UW SCSI)? How are drives configured (singleton drives, RAID 5, RAID 0, RAID 1, RAID 10)? Post these answers and your onstat -p and onstat -c and someone will try to give you tuning advice or platform advice. Art S. Kagel