Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2012
    Posts
    2

    Unanswered: Help me check what Block Size (paradox 4.5)

    ..my 4.5 Paradox tables use. So I can know what the maximum no. of rows in one of the tables is.
    I searched this forum and found information that the max no. of rows depend on which block size and what paradox version I am running.
    I am pretty sure that I am on Paradox 4.5.
    I have the BDEAdmin.exe tool, but cannot seem to make this show me what block size my tables are.


    I am in the unfortunate situation that I have inherited a 4.5 Paradox database, and I am not at all educated in this product.
    The reason I want to know my max row no. is because during a batchjob today a table errored that it was full. I did a "Modify" - "Restructure" of the table, and this helped, but I am anxious for how long it will help.

    Best regards, Olain!

  2. #2
    Join Date
    Dec 2007
    Posts
    366
    pdox tables usually have 2k or 4k blocks.. for a level 4 or level 5 table, max table size is 128 meg or 256 meg.. for a level 7 table, it's one gig or two gig.. if a table has secondary indexes, there are issues once a table is HALF the max size..
    --
    Steven Green - Myrtle Beach, South Carolina USA

    http://www.OasisTradingPost.com

    Oasis Trading Post
    - Collectibles and Memorabilia
    - Vintage Lego Sets and Supplies
    - and Paradox Support, too

  3. #3
    Join Date
    Aug 2012
    Posts
    2
    Dear Steve, thank you for replying.

    How can I know if I have a level 4, 5 or 7 table?

    Also, is it possible for me to check what block size my tables are set up to be?

    BR, Olain

  4. #4
    Join Date
    Dec 2007
    Posts
    366
    the defaults are in the BDE.. the settings for each table can be seen in the repair utility.. don't change them there, make a new table and pass the data, when chaning the settings
    --
    Steven Green - Myrtle Beach, South Carolina USA

    http://www.OasisTradingPost.com

    Oasis Trading Post
    - Collectibles and Memorabilia
    - Vintage Lego Sets and Supplies
    - and Paradox Support, too

  5. #5
    Join Date
    Dec 2007
    Posts
    366
    and if you're using 4.5, they're level 4 tables.. no other choices..
    --
    Steven Green - Myrtle Beach, South Carolina USA

    http://www.OasisTradingPost.com

    Oasis Trading Post
    - Collectibles and Memorabilia
    - Vintage Lego Sets and Supplies
    - and Paradox Support, too

Posting Permissions

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