Re: ifx performace: linux vs NT

Was there any measureable difference when you try bumped up the NUMAIOVPs and CLEANERS ? RP. Diego wrote: > Palmer: thanks for your input in this isssue. Let me tell you about the > tests: > > I started with a set of queries against 5 tables: one with 150.000 rows, > other with 250.000 rows and the rest pretty small ones. > > First, forcing the engine to sequential scan the whole table. > Then, queries of a single table, with a filter condition on a indexed field, > with and w/o the order by clause. > And last, a series of joins with filters conditions with and w/o the order > by clause. > > In most of the tests the linux box was slower...twice I must say. For > example, the sequential scan took NT 1 min and linux 2. > > I was going to continue with a series of more elaborated tests, but with > this figures I panic and post my onconfig for help. I belive I must be doing > something wrong. Anyone with a bright idea? > > System: > > Linux RedHat 6.0 / Kernel 2.2.5-15 > Informix IDS 7.30 UC7 > PII 350 Mhz, single cpu > 128 RAM > > NT 4.0 > Informix IDS 7.30 TC 5 > same HW > > Cooked files on both, (unbuffered on NT). Statistics updated. >