--0-2093187824-1065542758=:39267
Content-Type: text/plain; charset=us-ascii

RTFM (Performance Guide - Chapter 7). Here is the link to the PDF. Enjoy.

http://publibfi.boulder.ibm.com/epubs/pdf/8344.pdf

Dirk Moolman <DirkM@mxgroup.co.za> wrote:Or if I can put it another way -

am I correct in assuming I can calculate this by

1. calculating the table sizes (rowsize * nrows) ... if update statistics is up to date, and then
2. add to that (index size + 4) * nrows, for each index

Will this be close enough ?


-----Original Message-----
From: Dirk Moolman
Sent: Tuesday, October 07, 2003 10:36 AM
To: informix-list@iiug.org
Subject: FW: Upgrading from 7.31 to 9.3 - storage requirements

Anyone ?

-----Original Message-----
From: Dirk Moolman
Sent: Wednesday, October 04, 2003 10:38 AM
To: informix-list@iiug.org
Subject: Upgrading from 7.31 to 9.3 - storage requirements

I know that the indexes are detached in version 9, so upgrading from 7 to 9 will require more storage.

Question: Does anyone have a query I can use that will calculate my storage requirements for the upgrade ?




sending to informix-list

sending to informix-list

sending to informix-list


---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
--0-2093187824-1065542758=:39267
Content-Type: text/html; charset=us-ascii

<DIV>RTFM (Performance Guide - Chapter 7). Here is the link to the PDF. Enjoy.</DIV>
<DIV>&nbsp;</DIV>
<DIV><A href="http://publibfi.boulder.ibm.com/epubs/pdf/8344.pdf">http://publibfi.boulder.ibm.com/epubs/pdf/8344.pdf</A><BR><BR><B><I>Dirk Moolman &lt;DirkM@mxgroup.co.za&gt;</I></B> wrote:
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Or if I can put it another way - <BR><BR>am I correct in assuming I can calculate this by <BR><BR>1. calculating the table sizes (rowsize * nrows) ... if update statistics is up to date, and then <BR>2. add to that (index size + 4) * nrows, for each index<BR><BR>Will this be close enough ?<BR><BR><BR>-----Original Message-----<BR>From: Dirk Moolman <BR>Sent: Tuesday, October 07, 2003 10:36 AM<BR>To: informix-list@iiug.org<BR>Subject: FW: Upgrading from 7.31 to 9.3 - storage requirements<BR><BR>Anyone ?<BR><BR>-----Original Message-----<BR>From: Dirk Moolman <BR>Sent: Wednesday, October 04, 2003 10:38 AM<BR>To: informix-list@iiug.org<BR>Subject: Upgrading from 7.31 to 9.3 - storage requirements<BR><BR>I know that the indexes are detached in version 9, so upgrading from 7 to 9 will require more storage.<BR><BR>Question: Does anyone have a query I can use that will calculate my storage
requirements for the upgrade ?<BR><BR><BR><BR><BR>sending to informix-list<BR><BR>sending to informix-list<BR><BR>sending to informix-list</BLOCKQUOTE></DIV><p><hr SIZE=1>
Do you Yahoo!?<br>
<a href="http://shopping.yahoo.com/?__yltc=s%3A150000443%2Cd%3A22708228%2Cslk%3Atext% 2Csec%3Amail">The New Yahoo! Shopping</a> - with improved product search
--0-2093187824-1065542758=:39267--
sending to informix-list