Re: Informix Online

In article <D4IuzF.M2s@boi.hp.com>, daveje@gr.hp.com (Dave Jerzycki) wrote: > Can anybody tell me where I can get info on the differences/advantages > of SE vs Online engines? Why would I choose one over the other? > We currently have the SE version, but are considering the Online engine. > I need some data on the possible avantages on the Online engine. Here's what the FAQ says: Standard Engine (or just "SE") * Low administration requirements * Suitable for small to medium databases * Runs on "cooked" file-systems. Stephen Morrow (smorrow@dotrisc.cfr.usf.edu) has summarised responses to his question about how far people have pushed SE: * General consensus was that SE performance largely based on machine it's running on, size of memory, and SQL structure-- not on the engine itself * Several sites have 1-2+ GB DB's, tables w/ millions of rows, with up to 100+ concurrent users...each with acceptable response time * AIX appears to be a good platform for SE * No horror stories were received :-) Online Engine * Relatively high administration requirements * Copes well with large databases * Enhanced data types to cope with binary data, like pictures and sounds (ie: BLOBs and BYTEs) * Runs on "raw" file-systems (so faster than SE) --------------------------------------,------------------------------------- Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ Quanta Systems, Auckland, New Zealand | kcbbs.gen.nz:/informix/* | mathcs.emory.edu:/pub/informix/faq/* +64 9 377-4473 (work) 266-6011 (home) | http://www.garpac.com/informix.html