Subject: | Re: Table Full
| Date: | 13 Oct 2021 21:53:04 -0400
| From: | "Kevin Zawicki" <numberjack@wi.rr.com>
| Newsgroups: | comp.databases.paradox
|
>empty the copy
this is best advice, try it.
Steve Green <steve@oasistradingpost.com> wrote:
>it's not the number of records you look at first, it's the block size
>
>a level 7/8/9 table can have a block size of 2k (max size 128 meg), 4k
>(256 meg), 8k (512 meg), 16k (1 gig), or 32k (2 gig)
>
>open the repair tool, it'll tell you the block size
>
>if you need to increase it -
>
>make a copy of the table
>empty the copy
>change the block size of the copy
>add the original records to copy
>rename the copy
>
>do *not* try to change the block size with data in the table
>
>also, there are known issues with sec indexes once the table gets to be
>more than half the max size for the block size, so try to keep you table
>sizes within that limit
>
>
>--
>Steven Green
>Myrtle Beach, South Carolina USA
>
>http://www.OasisTradingPost.com
>
>Collectibles and Memorabilia
>Vintage Lego Sets and Parts
>- and Paradox support, too
|