Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    16

    Unanswered: Table size in Paradox 7

    Does anyone know how many records can be stored in a Paradox table?

    I have a query that is retrieving data from an Oracle table and am getting "Table is Full" error.

    The query is returning a total of 494,721 records.

    pbare

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas
    Posts
    182
    The available RAM determines the size of your table and it is not dependent on the number of records but on the total amount of data.

  3. #3
    Join Date
    Oct 2003
    Posts
    706
    "Incorrect." The amount of RAM actually has nothing at all to do with it.

    A Paradox table consists of up to 65,535 "blocks" of some multiple of 2K per block, with an integral number of records per block. The block-size is probably much too small. With 494,000-odd records, I'm sure of it.

    Block-sizes are changed by editing the BDE Configuration parameter, exiting and restarting Paradox, then constructing a new table with the same structure as the old. The Borland web-site at http://www.borland.com/devsupport/bde has a utility to do it.

    Index files are also "Paradox tables," and a "table is full" usually when any index to that table is full.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  4. #4
    Join Date
    Sep 2003
    Location
    Dallas
    Posts
    182

    When you are right you are right.

    Thanks Sundial,

    I have been using paradox for years (more than we want to count) and I do believe that version 4.5 (back when they had dos versions as well) had the Ram limit. But you are correct and forced me to review the current specs.

    Thanks

  5. #5
    Join Date
    Oct 2003
    Posts
    706
    No problem. We all indulge in improper slices of beef ("mis-steaks") ...

    ("Oops!", he said, quickly strapping on his tomato-proof bunny suit...)
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •