Re: Informix dual processor scalability

Stuart Britt writes: |> Does anyone have any info on the following problem? We are using Informix |> version 7.10.UC1 for Intel UnixWare 2.01 on single processor and SMP |> machines. |> |> Using Informix on 1 processor we achieve good performance. If we switch to |> 2 processors, then our performance actually degrades. We have been given |> some advice on tuning the system for dual processor machines and we have |> tried different settings for virtual processors and processor affinity. |> We managed to get an improvement, but the best scaling we can get is |> about 1.25. |> |> If we move to a quad processor system the problem goes away and we |> approach expected performance levels. |> |> Has anyone else experienced this? Yup. Generally speaking, it is rather difficult to get a 2 processor machine to scale well for a database server. You are just about better off tuning OnLine for a single cpu system when using only 2 processors. Dave Kosenko Disclaimer: All opinions expressed in this message are well-reasoned and insightful; needless to say, they are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. **************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney