2gb table - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

2gb table

Message

29/03/2005 13:00:37

29/03/2005 12:11:03

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:

00999752

Vues:

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