🚀 go-pugleaf

Mike Bandor wrote:
> 
> Richard,
> 
>         I tried increasing the block size to 4096 and creating a new
> table.  I then copied the data to the new table and started using it,
> but I still have the same problem.  Any other ideas?
> 
> D1.02, Win3.1, Paradox 5.0 table.
> 
> Original posting data:
> 
> DB Structure:
> 
> NAME            TYPE    SIZE
> ENTRY_NBR       +
> TERM            A               75
> MEANING         A               254
> EXPANDED        L
> E_MEANING       M               1
> COUNTRY         A               50
> BRANCH          A               25
> NEW                     L
> ASOFDATE        D
> VERSION         N
> REMARKS         A               200
> 
> I have looked up TI2751 and I don't seem to be at the limits according
> to the information it provides.  The total file sizes add up to
> 230,834,502 (much less than the 256Mb limit).  And I have
> approximately 800Mb of free disk space available as well.  Is there
> something I'm not looking at, or can I make a change somewhere to
> increase the number of records in the table?
> 

You have very large fixed-alpha fields, nearly 500 bytes per record,
that probably should be decreased or moved to memos, which at least
occupy a variable amount of storage.  Could it be that "E_MEANING" is
some enormous field?

If the file-sizes are 230MB then the additional 56MB could easily be
wasted by round-off.  You are reasonably close to the ceiling, and the
possibility remains that you could hit it.

Unless you are actually using all 500 A-bytes per record then you
probably need to come up with a different strategy for storing those big
A-fields.