RE: Slow OS calls on one chip type
Joerg pretty much covered it.
Could also be the OS too. Depending on if its properly tuned. You can see some issues like this too.
> Subject: RE: Slow OS calls on one chip type
> Date: Fri, 16 Apr 2010 00:35:56 +0200
> From: joerg@it-volz.de
> To: neil.truby@ardenta.com; informix-list@iiug.org
>
> Just some usual suspects:
>
> Misconfigured memory / mainboard parameters in BIOS?
>
> Memory in a slow slot layout (running, but not wrong enough to cause an
> error)? Or wrong speed?
>
> Faulty Mainboard? Had this once, caused strange errors, including
> intermittent speed behavior. Cause was a chipset chip with faulty
> soldering.
>
> Is a C/PERL/bash program also very slow, or only Informix programs?
>
> My personal experience is that AMD // Intel do work more or less within
> the same speed range, more problems occur with wrong memory and HD
> layout or SAS/SCSI Controllers.
>
> regards
> Joerg Volz
> ------------------------------------------------------------------------
> -----
>
>
> -----Original Message-----
> From: informix-list-bounces@iiug.org
> [mailto:informix-list-bounces@iiug.org] On Behalf Of Neil Truby
> Sent: Friday, April 16, 2010 12:04 AM
> To: informix-list@iiug.org
> Subject: Slow OS calls on one chip type
>
> IDS 11.5FC6 on RHEL 5.3
>
> Here's a starange one. When running SQL which interacts with OS to
> output
> messages, it's very, very much slower at a new customer site than it is
> at
> our own or others. The difference seems to be the AMD processors the
> customer has (we have Intel) - the OS and IDS versions are identical.
>
> Here's a a simple test case. Here's some SQL, which echoes out the
> message
> "Hello World" 64 times:
> !echo "Hello World"
> !echo "Hello World"
> !echo "Hello World"
> !echo "Hello World"
> ...
> !echo "Hello World"
>
> Run it on the AMD server:
>
> informix@db-1<qa1>:ardenta]$ time dbaccess sysmaster < crap5.sql
>
> Database selected.
>
> Hello World
> ...
> Hello World
>
> Database closed.
>
>
> real 0m7.776s
> user 0m0.016s
> sys 0m0.049s
>
> Run it on an Intel server, same IDS version etc:
>
> Hello World
> ...
> Hello World
>
> Database closed.
>
> real 0m0.580s
> user 0m0.005s
> sys 0m0.037s
>
> 12 times as slow on AMD. We noticed it when trunning some data load
> scripts
> which outputs thousands of progress messages, and went from 10m at home
> to
> 50m on the client's (far superior) hardware. Of course we could just
> omit
> the statements, but I am worried that this may be part of a bigger
> issue.
>
> IBM PMR 85722,019,866 refers.
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
> IT Handel und Beratung Jorg Volz
> Bernhard-Fruh-Str. 7
> 77855 Achern
> GERMANY
>
> Tel: +49 (0)7841-681651
> Fax: +49 (0)7841-681654
> Mobil: +49 (0)170-2989757
>
> VAT-ID: DE201383541
>
> http://www.it-volz.de
>
>
>
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
_________________________________________________________________
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
http://clk.atdmt.com/GBL/go/196390709/direct/01/