Can anyone advise how to calculate how many records I can get into a 1mb dtatabase - based on the average number of characters of data held in each record. Is it as simple as 1 byte per character?
TIA!
Alan
TIA!
Alan
Apr 24, 2000, 4:57 AM
User (223 posts)
Apr 24, 2000, 4:57 AM
Post #2 of 4
Views: 1593
Actually you'd want to base it on the average filesize used per record. Easiest way is to take your current database and divide its size by the number of records.
For example, my database is 87KB, and I have 166 records. So, my average record size is roughly 524 bytes (about 1/2K).
Now, take the rough physical size of a meg, in bytes, and divide by the average record byte size. (1,024,000 / 524). This calculates the estimated number of records I can have in a 1MB file: 1,954 records.
Of course, the actual number will be different, because not all of my records are 524 bytes. But this gives you a good estimate.
--Lee
For example, my database is 87KB, and I have 166 records. So, my average record size is roughly 524 bytes (about 1/2K).
Now, take the rough physical size of a meg, in bytes, and divide by the average record byte size. (1,024,000 / 524). This calculates the estimated number of records I can have in a 1MB file: 1,954 records.
Of course, the actual number will be different, because not all of my records are 524 bytes. But this gives you a good estimate.
--Lee
Apr 24, 2000, 6:26 AM
User (223 posts)
Apr 24, 2000, 6:26 AM
Post #4 of 4
Views: 1583
If not, you might want to consider snagging the SQL version of DBMan. Contact Alex, the author, for details on getting it. The SQL version can handle systems that exceed beyond the 1Meg filesize.