RE: Slow OS calls on one chip type
Posted in 2010
Topics: Server Administration
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/