Steven
Here is a possibility. Someone more familiar with dBase files than me may
be able to give you better information.
First by way of analogy ...
In the BDE version used with D1 the block size in effect (use bdecfg.exe to
look at it for Pdox tables) when you create Pdox tables limits the size of
the Pdox tables. One can have up to 65K blocks in a Pdox table (I hope this
is the right number).
For dBase files when you create a dBase file, if the bdecfg.exe settings
for the dBase MDX and DBT block sizes affect the size or performance of
your dBase files this could cause problems. I am guessing about this as you
have linked your problem to file size.
If your files have neither MDX not DBT files attached my suggestion may be
useless. Otherwise could you experiment with large files created with MDX,
DBT files made with larger block size settings?
At 16:16 24/01/99 +0000, you wrote:
>I have a Delphi 4 app that uses .dbf files via the BDE. Normally it
>works fine but for a select group of clients with larger than normal
>data tables I have discovered a probelm. Their Item table has about
>90,000 thousand records and if they use the app to add items it
>crashes after about 15 records have been added.
>
>Adding items also causes several other tables to have records added
>as well. The table are not closed between each addition
>
>The error I get is
> "Read failure
> (Path and name of Item table)
>
>(Note that I don't get this problem with tables with 12,000 records
>dispite adding 100s of records in one session but have not worked
>out at what point it does start!)
>
>Following sound advise that my code was at fault I searched it for
>errors. Then I ran Memory Sleuth over it. Interestingly enough,
>after adding each entry, Sleuth returns that there is 517,824 bytes
>in uses and 7119 pointers active. I read this as no problems!
>
>However after entering about the right number of records for the
>fault to occur - it did (showing figures of 518,188 & 7125 at the
>actual instance).
>
>Changing the database isn't an option. Is it the BDE or something
>else completely?? What other tests should I mount?
>
>Steven
>
>
>Wild Software Ltd
>P O Box 33-216
>Christchurch
>NEW ZEALAND
>
>=========================================================
>I haven't lost my mind; it's backed up on tape somewhere.
>=========================================================
>---------------------------------------------------------------------------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
>
>
Russell Belding
Belding Computing Devices
WINLAW, BIZXWORD, ENGPER.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
