> In a situation where we have to use dbf tables and the BDE 5.1 we have a
> problem when we have two applications running on the one machine and both
> are accessing the bde. One of them is adding records to a table with a
> bit over 4,000,000 records and 6 indexes in it and the other is wanting to
> view records from the same table. THe one wanting to view is forced to
> wait until the updating is finished.
>
> If the second app is run on a different machine but looking over the
> network at the same tables it gets immediate access to the table while it
> is being updated.
>
> Our conclusion is that the BDE can only adequately service one application
> at a time and so it works OK over the network because each app is using a
> separate copy of the BDE. Assuming that our conclusion is correct how do
> we get the BDE to support two apps concurrently on the one machine?
>
> Steven
>
BDE can service multiple apps on a single machine.
Adding a row to a 4,000,000 million row dBase table with 6 indexes is
probably reasonably intensive for the BDE and requires a bit of resource. It
may be stretched trying to add and allow another app to view at the same
time.
I'd try massaging some of the resource parameters in the BDE (under System /
INIT) like MEMSIZE, SHAREDMEMSIZE and MAXBUFSIZE. (I haven't tried this, but
it's the best I can suggest)
HTH,
Mike
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
