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>