Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is the 2 gig size limit for tables or for the fpt file.
Message
From
11/06/2002 16:12:04
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00667062
Message ID:
00667073
Views:
23
>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)
  • Previous
    Next
    Reply
    Map
    View

    Click here to load this message in the networking platform