HELP: 80286 Informix 3.3 vs. SCO Unix/386 3.2.2

Path: emory!samsung!uunet!tiamat!jim From: jim@tiamat.fsc.com ( IT Manager) Newsgroups: comp.unix.xenix.sco,comp.unix.sysv386,comp.databases.informix Message-ID: <2079@tiamat.fsc.com> Date: 29 Oct 91 15:40:31 GMT Organization: Ahlstrom Filtration - Chattanooga,TN I've tried to use a narrower aim in getting my current situation resolved, but I've had little success. Perhaps a wider audience will produce a greater possibility for a solution. Here's the situation: We have an accounting application written in Informix 3.3 (Informix's original database product, NOT the SQL product). We started out using this application with an 80286 version of Informix 3.3 on an Altos 2086 box. Later, we put the accounting dept. on their own 386 PC, and started using Xenix 386 as the operating system. In both of these configurations (i.e. an 80286 and an 80386 version of the Xenix OS), the 80286 version of Informix 3.3 ran just fine. Recently, we decided to install SCO Unix 386 (via ODT 1.1) on the accounting computer. Since SCO Unix 386 listed Xenix-compatibility (even for 286 Xenix binaries) as one of its attributes, I figured we were in good shape. Well, under SCO Unix 386, the 80286 Informix 3.3 binaries do work. BUT, they are very, very, very, very slow. For instance, some operations (especially update operations) that used to take 5 minutes may now take as long as 40 to 50 minutes. I'm not sure if it is the OS or the Informix binaries that are at fault. Here's the questions: 1) Is there a 80386 version of Informix 3.3 out there somewhere? My Informix sales rep doesn't seem to be able to find one in their product lists. I'd imagine that if the problem is with the 80286 binaries running slowly, that any 80386 version (e.g. one for Xenix 386, ISC Unix 386, Intel Unix 386, etc) might help. 2) Could the problem be in the way SCO Unix 386 deals with 80286 binaries and is there any way to tune the system so these old binaries will run faster? 3) Any other suggestions (except: repalce the application, or rewrite the application in Informix SQL) that might be useful in keeping both the Informix 3.3 applications and the SCO Unix 386 OS on the same box. Thanks for any help. I sure hope someone out there has an answer for me. ------------- James B. O'Connor jim@tiamat.fsc.com Information Technology Manager voice 615/821-4022 x651 Ahlstrom Filtration, Inc. fax 615/821-0616