Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C++
I'm gonna create a file to save a large database. But I don't know how big it can be at most. what are the factors to define maximum size for a file?
Posted 31-Oct-11 9:54am
Comments
Richard C. Andrews at 31-Oct-11 16:06pm
   
Are you creating this database using source code or are you using a program?
If you are using a program, what program?
If you are using source code, on what platform do you intend on using the database?
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

The theoretical limit on NTFS is 16 TB (minus a few KB).
  Permalink  
Comments
Espen Harlinn at 31-Oct-11 15:33pm
   
5'ed - 18,446,744,073,709,550,592 bytes (actually limited to 17,592,185,978,880 bytes, but the design provides for the larger number) - Wikipedia
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Your drive space, and the the operating system define the limits of the maximum file size.
 
Assuming you're running Windows Vista or Windows 7, your file size can go into the terabytes.
 
This isn't really a C++ question though.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

(I haven't done a lot of DB in a while)
"what are the factors to define maximum size for a file?"
 
You need to compute the data size for one record in your database. (i.e. sum of the size of each field,)
 
Then your check what are the requirements for your database, what is the number of records your database should hold, then just compute the maximum size you will need.
 
When that is done, you will have to decide the best method to handle that amount of data.
 
Max.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 341
1 Marcin Kozub 225
2 Sergey Alexandrovich Kryukov 220
3 Praneet Nadkar 197
4 Shweta N Mishra 161
0 OriginalGriff 8,149
1 Sergey Alexandrovich Kryukov 7,287
2 DamithSL 5,614
3 Manas Bhardwaj 4,986
4 Maciej Los 4,910


Advertise | Privacy | Mobile
Web03 | 2.8.1411023.1 | Last Updated 31 Oct 2011
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100