All right so let me explore BDE settings: In my DBF tables I only
use Number, Character, Date, and Logical field types. There are no
memo fields so no DBT files. I use standard MDX production index
files. The indexes involved in this prolem are all field rather than
expression indexes.
The configuration of the DBASE native driver in the BDE (5.01) is as
follows:
Version: 4.0
Type: File
LangDriver: dbase ENU cp437
Level 5
MDX Block size: 1024
Memo file block size: 1024
I can't necessarily justify any of these settings and am prepared to
experiment if someone can give some direction!
Steven
> 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
>
>
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
