dbTalk Databases Forums  

Re: Maximum number of pages for a partition

comp.databases.informix comp.databases.informix


Discuss Re: Maximum number of pages for a partition in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Claus Samuelsen
 
Posts: n/a

Default Re: Maximum number of pages for a partition - 10-07-2010 , 01:55 PM






On Oct 6, 6:41*pm, "Neil Truby" <neil.tr... (AT) ardenta (DOT) com> wrote:
Quote:
10.0FC10 on Solaris

I have a table fragmented round-robin over three dbspaces,. close to hitting
the 16775000 page limit (see oncheck below).
If you can upgrade to v11.x, you will have the option to use
compression. Depending on the variation of the data you may see a
compression percentage better than 50%. There is a small tool that can
be used on version 7, 9 and 10 to calculate an expected compression
ratio. http://www-01.ibm.com/software/sw-li...S36452U64.html

Reply With Quote
  #2  
Old   
Art Kagel
 
Posts: n/a

Default Re: Maximum number of pages for a partition - 10-08-2010 , 02:46 PM






Compression is still an extra cost option even in ultimate edition.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)

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 Thu, Oct 7, 2010 at 2:55 PM, Claus Samuelsen
<claus.samuelsen (AT) gmail (DOT) com>wrote:

Quote:
On Oct 6, 6:41 pm, "Neil Truby" <neil.tr... (AT) ardenta (DOT) com> wrote:
10.0FC10 on Solaris

I have a table fragmented round-robin over three dbspaces,. close to
hitting
the 16775000 page limit (see oncheck below).

If you can upgrade to v11.x, you will have the option to use
compression. Depending on the variation of the data you may see a
compression percentage better than 50%. There is a small tool that can
be used on version 7, 9 and 10 to calculate an expected compression
ratio.
http://www-01.ibm.com/software/sw-li...S36452U64.html
_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.