Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Kern Doe asked if compression in Informix 11.50 is free. Carlton Doe said compression came in 11.50.xC4 and needs an extra license on Ultimate Edition, while repack and shrink are free and defragment is free from 11.7. Neil Truby and Art Kagel said it is a chargeable add-on, included in Ultimate Warehouse Edition. Schil Ache claimed it is free for Enterprise.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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 — — 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 — — 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.
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
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
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.