Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Distributing and using VERY large tables.
Message
De
14/08/2001 03:32:13
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00539842
Message ID:
00543384
Vues:
14
Maybe data in the others copmpanies tables is well organized . For example , strings like street names can be "compressed" to very short strings by using some "smart" functions, like those used for encryption and compression in archives . In cases where are many long character fields compression can be very strong . But this methods slows speed in working with records . If there are 3 fields with 30 length and they are reduced to 10 each, to 35 million records means (30-10)bytes*35000000*3=aprox. 2GBytes (!) less harddisk space occupied . Did I calculate correctly ?!!!
If you saw files like d00, d01, maybe the other companies break data in many files. For example, every district has a different file and these names are memorised in a file to be known where to search data .

Mihai
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform