Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pack issue on large DBF
Message
From
17/03/2015 16:45:05
Denis Filer
University of Oxford
United Kingdom
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Pack issue on large DBF
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01616914
Message ID:
01616914
Views:
56
We have a DBF table with 3.6 million records, about 1.6 GB. The FPT is about 1 GB. The file unexpectedly would not pack. We were very concerned the file was corrupted. However, seems not corrupted and by splitting to two files 50% each, packing and merging, the entire file now seems to pack OK. Is there any logic in this?
Thanks if any one has a clue.
(Incidently, wonderful VFP runs extremely well at this size. One of the table, smaller is GB has 5 millions records.)
Next
Reply
Map
View

Click here to load this message in the networking platform