Re: IDS & Workgroup Edition

John H. Frantz wrote in message <366D3928.E7586C67@rl.is>... >I'm finding it hard to determine what the essential differences in >functionality are between plain IDS and the Workgroup Edition. I've >gathered the following information from various sources, but I'm not >sure if it's all completely true, especially for the latest releases >(7.3x): > >1. No table fragmentation in WE. Not strictly true since you can still employ table fragmentation within the CREATE TABLE clause - I think you can't use PDQ's on fragmented tables as itwon't spawn multiple threads to scan each fragment. >2. No PDQ in WE. Correct >3. Limited replication (no update anywhere) in WE. Again, not strictly true. You can still schieve CDR & HDR ( certainly with 7.3 WE ) >4. Only one instance per machine with WE. Not true at all - You can have multiple instances if you wish ( but why is another matter ) >5. WE includes the Netscape web server, etc. True... >6. Only one CPU VP with WE (?). Again, not strictly true. You can have up to 3 CPU VP's >7. WE is limited to machines with 4 processors or less (?). True ( although, I havn't tried it on larger machines). The other major difference is in its parallel option - you can't perform parallel archiving & restores, no PDQ's ( so DSS queries are out of the window ). Oh yes, and its cheaper !! In 7.3 and above, I have heard through the grapevine that the above differences are irrelevant ?? Has anyone else heard the same ?? Hope this helps Sean > >Is this all correct and is there anything else I'm missing? > >Items 6 and 7 seem to contradict one another. Why limit the number of >processors if only one CPU VP will be running anyway? > >Does Informix have a web page that details the differences? > >WE seems to be about 5 times cheaper per user license. The jump in price >from WE to plain IDS is so big that one wonders why there isn't a level >between the two. For example, if you're using WE and your database needs >grow slightly to require an additional CPU VP without needing other >features, the cost for ten users goes from $3,000 to $15,000 - kind of >dramatic! > >Thanks for any pointers, >________________________________________________________________ >John H. Frantz Power-4gl: Extending Informix-4gl >john@rl.is http://www.rl.is/~john/pow4gl.html