General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Andy,
Not Hilmar obviously, but the VFP Help lists 1 billion as "Maximum # of records per table file". Searching on "billion" yileds the same extract only.
Since the DELETE mark is integral to tables, I still don't see how you get 2 billion. Yes, it can address 2 billion records without breaking I WOULD PRESUME but that can never happen so it is moot.
Jim
>Hi Hilmar
>
>>I don't quite agree here.
>>
>>The file-size limit is 2 billion records. This limits the number of records to 1 billion records, since a record can't have less than 2 bytes. See the part of a previous message, below.
>>
>>In actual practice, of course, you will never have records that small.
>
>I don't understand, what don't you agree with? That VFP can deal with a single file with 2 billion records is not a figure I plucked from thin air <s>. It is what what the documentation for the product states.
>
>As I said, that has nothing to do with whether you can actually create a file with 2 Billion records in it! It merely says that VFP will not break because it cannot deal with the number of physical records - unless that number exceeds 2 Billion!
>
>Do you know something different then? (Since you are disagreeing) Please share your knowledge...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only