Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
2gb table
Message
From
29/03/2005 13:00:37
Sylvain Larin
Montréal, Quebec, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: 2gb table
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00999740
Message ID:
00999752
Views:
53
Some options:
  • Pack the table if there are many deleted records
  • Reduce the length of the fields if you can
  • Split the table horizontally (TableA contains Field1 to FieldN, TableB contains FieldN+1 to FieldX)
  • Split the table vertically (TableA contains records 1 to N, TableB contains records N+1 to X)
  • Move to SQL Server/MSDE/etc.

    Good luck

    >how do i fix a 2gb table???
    • Previous
    Next
    Reply
    Map
    View

    Click here to load this message in the networking platform