Doug,

When I do the math I come up with a different # (see below):

File name ..................   TEST_FILE
Pathname ...................   TEST_FILE
File type ..................   DYNAMIC
File style and revision ....   32BIT Revision 12
Hashing Algorithm ..........   GENERAL
No. of groups (modulus) ....   82850 current ( minimum 24, 104 empty,
                                            26225 overflowed, 1441 badly )
Number of records ..........   1157122
Large record size ..........   2036 bytes
Number of large records ....   576
Group size .................   4096 bytes
Load factors ...............   80% (split), 50% (merge) and 80% (actual)
Total size .................   449605632 bytes
Total size of record data ..   258687736 bytes
Total size of record IDs ...   19283300 bytes
Unused space ...............   171626404 bytes
Total space for records ....   449597440 bytes

------ 
258,687,736 bytes - Total size of record data
19,283,300 bytes - Total size of record IDs
===========
277,971,036 bytes (record + id's)

277,971,036 / 4,084 = 68,063 bytes (minimum modulus)
------ 

68,063 is less than the current modulus of 82,850. Something with this formula 
doesn't seem right because if I use that formula I always calculate a 
minimum modulus of less than the current modulus.

Thanks,

Chris



> Date: Mon, 2 Jul 2012 16:08:16 -0600
> From: dave...@gmail.com
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] RESIZE - dynamic files
> 
> Hi Chris:
> 
> You cannot get away with not resizing dynamic files in my experience.  The
> files do not split and merge like we are led to believe.  The separator is
> not used on dynamic files.  Your Universe file is badly sized.  The math
> below will get you reasonably file size.
> 
> Let's do the math:
> 
> 258687736 (Record Size)
> 192283300 (Key Size)
> ========
> 450,971,036 (Data and Key Size)
> 
> 4096 (Group Size)
> - 12   (32 Bit Overhead)
> ====
> 4084 Usable Space
> 
> 450971036/4084 = Minimum Modulo 110424 (Prime is 110431)
> 
> 
> [ad]
> I hate doing this math all of the time.  I have a reasonably priced resize
> program called XLr8Resizer for $99.00 to do this for me.
> [/ad]
> 
> Regards,
> Doug
> www.u2logic.com/tools.html
> "XLr8Resizer for the rest of us"
> _______________________________________________
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
                                          
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to