Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Sizes - a nice easy request |
Wed, Jan 21 2009 8:07 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | I'm trying to work out the consequences of some table structure changes in terms of file sizes. Is there a guide anywhere? I had a look through the help pdf and couldn't spot anything.
If it included suggestions on calculating index sizes that would be a major bonus. Roy Lambert |
Wed, Jan 21 2009 10:51 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I'm trying to work out the consequences of some table structure changes in terms of file sizes. Is there a guide anywhere? I had a look through the help pdf and couldn't spot anything. If it included suggestions on calculating index sizes that would be a major bonus. >> There really isn't any way to calculate index sizes ahead of time without knowing the actual data, due to the compression used. For non-primary key indexes, the size of the index will be smaller (compared to a full index without compression) as the amount of duplicate index keys in the index grows. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Jan 21 2009 1:00 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
In that case hows about the data? I seem to remember a post about you'd reduced the size of storeage needed for an integer. Roy Lambert |
Wed, Jan 21 2009 6:16 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< In that case hows about the data? I seem to remember a post about you'd reduced the size of storeage needed for an integer. >> Not integers, but the size of DECIMAL/NUMERIC columns is much smaller (-28 bytes), and the size of BLOB column information in a row is smaller by 4 bytes. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, May 4, 2024 at 09:18 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |