Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 10 Apr 1997 15:23:05 +0900 (KST)
From:      grog@lemis.de
To:        hackers@FreeBSD.ORG (FreeBSD Hackers)
Cc:        chat@FreeBSD.ORG (FreeBSD Chat)
Subject:   Informix efficiency--any ideas?
Message-ID:  <199704100623.PAA01255@papillon.lemis.de>

next in thread | raw e-mail | index | archive | help
This message doesn't really have anything to do with FreeBSD, but
possibly somebody here has an idea.  As a result, though it's a
technical subject, please follow up to -chat.

I'm currently in Korea looking at a performance problem with Informix
on a MIPS System V platform.  We are comparing two MIPS platforms with
different System V.4 implementations, A and B.  The A machine is an
SMP with 2 R4400s at 200 MHz; the B machine is an SMP with 2 R4400s at
150 MHz.  B runs a specific, and relatively simple, DB insert program
almost exactly twice as fast as A.

We did some examination and found that the port of Informix on A
performs 21729 system calls to insert 5000 records into a table.  Of
these, 21403 calls are to semsys.  B performs approximately half this
number of calls, equally split (what a surprise) between send() and
recv(): although it's System V.4, it has a native sockets
implementation.

I'm obviously following this up with Informix and vendor A, but I'd be
interested if anybody here had a view with a different bias.  Do
semaphores have to be so much less efficient, or could this just be a
poor semxxx() implementation on A?

Greg




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?199704100623.PAA01255>