Upgrading from a previous old version of Informix to 14.10 and looking at Innovator-C. It's for a small business and definitely the limits seem within reason. 8gb RAM (probably uses half a gig at the most now), 50gb disk? Partitions are at most 4gb for data with probably less than 3gb used, 1gb for tempdbs. So each client is fine.
How is the 50gb disk limit counted? For an individual client we're a LONG way from coming close to the 50gb limit. But on development, I'm not so sure because we have a lot of copies of client databases and databases for sales demo scenarios.
Currently, we have 3 instances running, each with their own oninit. One each for demos (10.5gb), testing (17gb), and development (21gb). For a total of 48.5gb. Each instance is well within 50gb. But if all 3 are counted in total, we're almost running up against our 50gb limit - if that's how it's enforced.
Granted, I'm sure this is over-allocated and I added way more than I needed just to avoid out of space errors. They can probably be cut back. But do we need to? Or would three 20gb instances for a total of 60gb be fine? Just so long as each instance is under 50gb?
Or if we run out of space, do we just have to operate differently? Maybe allocate much less space and swap databases in and out on demand as needed? Drop the Jones database and load the Smith database?
Or set up different machines for all 3 uses? Then I don't need 3 instances on one machine, they can be on different machines, each subject to its own 50gb limit?
-Joel Schumacher