Re: TPC and Informix

>From: uunet!baloo.ee.byu.edu!kelly (J. Kelly Flanagan) >Subject: TPC and Informix >Date: 27 Aug 92 15:29:21 GMT >X-Informix-List-Id: <news.1721> > > How simple is Informix to install on a 486 machine running > UNIX? I can run Interactive SYSV R3.2 or DELL UNIX SYSV R4. Very. As root, use cpio (or possibly tar) to extract product off distribution media into directory where product will live -- /usr/informix is the normal place. Then run the install script (./installsql, ./installstar, or whatever) to brand the product. End of installation. If you are commissioning OnLine and want to use raw disks (a good idea), then you need to know how to set up a raw partition which is not being used by Unix. This can be tricky to do retrospectively -- but it is a problem with Unix rather than Informix per se. > I keep hearing about tuning the database, is this required? > How difficult is this to do? It depends on the engine. Standard Engine is not very tunable -- it is simple to install and largely idiot-proof. OnLine is considerably more complex and does benefit from tuning, though even untuned configurations work, often surprisingly well considering... More important, in general, is tuning the database design, and the way the application uses the database. As many performance problems are due to poor application design as they are to engine performance. > Will the TPC-A and TPC-B benchmarks run on Informix? Has > anyone done it that could share their code with me? Of course they do. I don't have shareable code, I'm afraid. Are you sure you want to do TPC-A on a 486? The difficulty with TPC-A is the terminal handling rather than the database handling. Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>