Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pack issue on large DBF
Message
De
17/03/2015 16:45:05
Denis Filer
University of Oxford
Royaume Uni
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Pack issue on large DBF
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01616914
Message ID:
01616914
Vues:
55
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.)
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform