Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Very Large FIle FREAD
Message
From
06/01/1999 08:35:02
Robert Byrd
National Association of Homebuilders
Washington, District of Columbia, United States
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00169987
Message ID:
00173091
Views:
25
It is a text file. It comes from a mainframe via DYNAM cartridge. I have no control over how large it is. And I know of no tool that can split it properly (at a linefeed). It is data for a quarterly update for a SQL Server 6.5 database. I am using Fox to do the QC and preprocessing. It get larger every quarter and has finally surpassed the 2 GB threshold.

A FEOF() returns .T. I have not tried a FSEEK. I'll have to get back to you on that.

Bob


>Is this a text file? My text files have gotten pretty big, but never over 2GB! WHat Fox users have recommended over the years for large tables over 2GB is to create smaller tables, and create a relationship between them.
>
>Your gonna be using FGETS to pull in data from the file? Does it hang up if you just keep pulling data out line by line?
>
>I presume you've tried FSEEK(gnFileHandle, 0, 2) to determine the EOF?
>
>If it's just a dumb text file your extracting data from, certainly you could split it into several smaller files and tackle the one at a time in code?
>
>>Has anyone done an FOPEN and FEOF on a file that is larger than 2.1 GB? I seem to be able to do the FOPEN, but the FEOF returns .T.
>>
>>Regards, Bob
Database Development Team
Previous
Reply
Map
View

Click here to load this message in the networking platform