Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Maximum DBF size
Message
From
19/12/2001 11:44:13
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
19/12/2001 09:30:56
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Maximum DBF size
Miscellaneous
Thread ID:
00596083
Message ID:
00596199
Views:
29
>>>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
    • Previous
    Next
    Reply
    Map
    View

    Click here to load this message in the networking platform