Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is the 2 gig size limit for tables or for the fpt file.
Message
De
11/06/2002 16:12:04
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00667062
Message ID:
00667073
Vues:
22
>I have a table that the dbf is just over 1 meg but the fpt file is rapidly approaching 2 gigs and I wondered if the 2 gig limit applies the that file as well. In case it matters workstations are windows 98 but file resides on server which is windows 2000. Thanx for any help.
>
>Walt

Both.

You can consider client/server, but there also are several other things you could do first, for instance:

  • Pack will reclaim wasted space.
  • Keep pictures out of the database - just save them as JPG files, and have the filename in a character or short memo field.
  • Split your table horizontally or vertically.
  • Proper normalization often saves some space, and makes individual tables smaller.

    HTH, Hilmar.
    Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
  • Précédent
    Suivant
    Répondre
    Fil
    Voir

    Click here to load this message in the networking platform