Understanding the Data Flow

We'll look at the data flow first. This will allow us to get an overall view of the needs that are met by the architectural elements. Once the general needs are understood, it is much easier to understand why Informix is doing what it does.

You'll find that the overall Informix system architecture is a tradeoff between multiple factors. Some decisions are made to enhance speed. Others sacrifice speed for security. Still others sacrifice speed and security for memory or disk savings. Like any vendor, the people at Informix have tried to present a product that offers tradeoffs that are reasonable to the largest possible audience. In some cases, the DBA can work around these tradeoffs by tuning the database or the application. ...

Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.