Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Very Large Data Files
Message
From
28/01/2002 07:29:21
Walter Meester
HoogkarspelNetherlands
 
 
To
28/01/2002 07:00:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00611039
Message ID:
00611443
Views:
27
Hi hilmar,

>>You can split the table in two vertically: This means you have one PK commonly in thos table, but for the rest of the columns you spread them over those two files. Of course you'll have to adapt your program.
>
>Horizontally, too: for instance, one table for each year or month, or by geographical regions. This may required major rewrites of the programs.

I know, but gareth specifically asks for a solution to have 12 tables of arround 2 gig into one table. IOW he has partitionated them horzontally and is looking for an alternative.

Walter,
Previous
Reply
Map
View

Click here to load this message in the networking platform