Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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,
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement