Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>You can:
>>>
>>>
Keep the text files as separate files, and only maintain a reference (the filename) in a DBF field.
>>>Split the DBF file horizontally, for instance by years.
>>>Split the DBF file vertically, if you have more than one large field.
>>>Use a database server, like Oracle or SQL-Server, as back-end.
>>
>>Hilmar,
>>
>>I understand how you could easily split the file horizontally as long as there is something logical like years to use. So you would have to have a logical break to do this? Is there a way to have 2 files and have Foxpro use them like they are only 1? Also, how would you handle the verticle split? Common key between them?
>
>'Tis a daunting task, but it can be done in theory. The basic idea is to use SELECT - UNION to combine the tables. Saving to the appropriate table based on the date range would be more complicated. All I can say, I hope this doesn't happen to me...
>
>I understand they used both horizontal and vertical splitting for the Eurotunnel (128 GB of data total). This is outlined in an article in FoxPro Advisor. Don't remember the month and year.
>
>Hilmar.
Thanks!
BTW, is your sig quoted from Finnigan's Wake? I actually got about a third of the way through it before giving up. Always meant to go back and try again...
Renoir
Précédent
Suivant
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
