2gb table - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

2gb table

Message

29/03/2005 17:33:09

29/03/2005 13:00:37

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Versions des environnements

Visual FoxPro:

VFP 7 SP1

OS:

Windows XP SP2

Network:

Windows 2000 Server

Database:

Visual FoxPro

Divers

Thread ID:

00999740

Message ID:

00999807

Vues:

All good options except MSDE. That has a 2GB limit in TOTAL!

cheers

>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???