![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
![]() |
Wed, Jan 21 2009 8:07 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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. ![]() | 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 ![]() | 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. ![]() | 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 Monday, July 15, 2024 at 07:03 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |