Strange advises

CROSSPOSTED: ukr.comp.dbms.informix Hi Informixers, I have two very strange recommendations that isn't true from my point of view from one my consultant. I hope Informix community is able to make the advises more clear for me. HPUX 10.20 IDS 7.30UC8 The first is "You have KAIO running. We are aware that this feature is causing performance problem with Informix implementation. Recommend to not enable it" I haven't ever crossed with any problems that is related with performance under HPUX. Maybe somebody has different experience ? The second advice is very interesting for me. "Even though your host is multi-processor, it is better to configure as NON-MULTIPROCESSOR. If not too many mutex, which is currently being experienced. MULTIPROCESSOR 0" Other multi-CPU parameters hasn't been changed. NUMCPUVPS 2 SINGLE_CPU_VP 0 AFF_SPROC 0 AFF_NPROCS 2 After changing the parameter I haven't seen any big difference in "onstat -g spi". Does the advice have any effect in my system ? If it's true how can I recognize the effect from statistics ? Any input will be very appreciated Regards, Eugene Nechayev Sent via Deja.com http://www.deja.com/ Before you buy.