Board index » delphi » Large Paradox database - What 'block size'?

Large Paradox database - What 'block size'?

In article <34b46cec.622...@news.umac.mo>, Francisco Leong
<d941...@umac.mo> writes

Quote
>On 7 Jan 1998 15:58:01 -0700, news-re...@sundialservices.com (Sundial
>Services) wrote:

>>The block-size of a table, ironically enough, *isn't* a parameter that you can
>>specify when you create the table .. beats the hell out of me why.  It's an
>>IDAPI Configuration Utility setting for the Paradox driver.  All tables
>>created since that setting is changed, use the current setting.

Thanks.. found it. Unfortunately all my attempts to change the block-
size still result in Table Full error at 130 meg+. I have done as you
suggest. I have tried changing to 4k then to 8k etc. up to 32k
(restarting the machine afterwards, making a new database then borrowing
the table structure then copying in the records from the old version via
Database Desktop) each time to no avail. Each record consists of four
fields (an autoincrement field, a 1 char alpha field, a 30 char alpha
field and a Long Integer field, all are index fields. The number of
records will ultimately be approx 6 million (it's a step in making a
dictionary index).

Any thoughts?
--
Fred Gibson

 

Re:Large Paradox database - What 'block size'?


Quote

>Thanks.. found it. Unfortunately all my attempts to change the block-
>size still result in Table Full error at 130 meg+. I have done as you
>suggest. I have tried changing to 4k then to 8k etc. up to 32k
>(restarting the machine afterwards, making a new database then borrowing
>the table structure then copying in the records from the old version via
>Database Desktop) each time to no avail. Each record consists of four
>fields (an autoincrement field, a 1 char alpha field, a 30 char alpha
>field and a Long Integer field, all are index fields. The number of
>records will ultimately be approx 6 million (it's a step in making a
>dictionary index).

>Any thoughts?

Solved. I was changing ADAPI.cfg ins of ADAPI32.cfg in the BDE Config
utility (!).

--
Fred Gibson

Other Threads