Is compression feature available on 11.50 at no co

Posted in 2013

Kern Doe — Thu, 17 Jan 2013 03:29:07 — source: IIUG Forums & Mailing Lists

I'm eager to try this feature in the very near future to see how much it will improve IO, backup performance, query performance, etc. but would like to know if it is free. Thanks in advance for any info. Kern --

↪ replying to Kern Doe

Carlton Doe — Thu, 17 Jan 2013 03:54:15 — source: IIUG Forums & Mailing Lists

Compression was introduced, along with repack and shrink, in 11.50.xC4. = While repack and shrink may be used without charge on any edition, = compression requires an additional license and can only be used with = Ultimate Edition. As an FYI, defragment was added in 11.7 and is free to use on any = edition. Carlton ------------------------------------------------- Carlton Doe Flower Mound, TX No trees were killed in the transmission of this email, however a large = number of electrons were temporarily inconvenienced.=20 On Jan 16, 2013, at 9:29 PM, "Kern Doe" <kern_doe@yahoo.com> wrote: > I'm eager to try this feature in the very near future to see how much = it will=20 > improve IO, backup performance, query performance, etc. but would like = to know=20 > if it is free. Thanks in advance for any info.=20 > Kern --=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20

↪ replying to Kern Doe

NEIL TRUBY — Thu, 17 Jan 2013 09:54:05 — source: IIUG Forums & Mailing Lists

It is most definitely not free. It's a chargeable add-on to Ultimate Edition only, and weighs in at around US$820 per "PVU", or $6,000 to $8,000 per modern x86 core, so it's very much a product for the high-end user.

↪ replying to NEIL TRUBY

SCHIL ACHE — Fri, 15 Feb 2013 08:14:09 — source: IIUG Forums & Mailing Lists

Hi , For enterprise its free. Its beautifull on disk usage ( ~ 70% save space). I/O is good.But if your table have insert/delete/update more than select stmts, slow little bit (negligible) :-) rgds schillache

↪ replying to SCHIL ACHE

Art Kagel — Fri, 15 Feb 2013 11:43:01 — source: IIUG Forums & Mailing Lists

Um, NO, the Storage Optimization feature, or table data compression, is NOT free with the Ultimate Edition (used to be called Enterprise Edition) it is an extra cost add-on. It IS included with the Ultimate Warehouse Edition which also includes the Informix Warehouse Accelerator but that is a more expensive edition than the base Ultimate Edition. (Note that buying/upgrading to Ultimate Warehouse Edition is cheaper than adding Storage Optimization alone to an Ultimate Edition license and you get IWA too!) This was all pointed out during the original thread last month. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Feb 15, 2013 at 3:14 AM, SCHIL ACHE <penfriend5@yahoo.co.uk> wrote: > Hi , > > For enterprise its free. Its beautifull on disk usage ( ~ 70% save space). > I/O is good.But if your table have insert/delete/update more than select > stmts, > slow little bit (negligible) :-) > > rgds > schillache > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d0401fa5d4cab1404d5c1e0d2