Are you using TDatabase & TSession?
Do you have the same private directory in use for both apps accessing the
same DB (or something similar)?
Sounds like a locking/resource conflict in that both your apps on the same
machine are trying to use the same file/resource in common. I have found
that with the BDE you need to have different private directories for each
version of the app you are running on the same machine.
The second app running from a second machine, only proves that the problem
probably lies in your code or usage of the BDE/Tables - must be some
parameter/configuration you can change to get round the problem - it's a
question of which one.
Myles.
> -----Original Message-----
> From: Steven Wild [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 27, 1999 10:40 AM
> To: Multiple recipients of list database
> Subject: [DUG-DB]: Re: BDE
>
> Maurice
> We accept that our table is too large (at 550MB with an MDX at
> 720MB) but the size has been useful for emulating what other
> clients are experiencing with smaller datasets on slower machines.
>
> The original message is appended at the bottom for anyone who
> has more light to shine on it!
>
> Steven
>
>
>
>
> On 22 Sep 99, at 16:30, Maurice Butler wrote:
>
> > How large, I found performance drops off dramatically when table size
> > exceeds 10 Meg (not surprising as the flat file format was designed when
> > 20 Meg hard discs where in vogue and if your got a 40 Meg disc you had
> to
> > partition it into 32 Meg chunks).
> >
> > -----Original Message-----
> > From: INTERNET:[EMAIL PROTECTED]
> > Sent: Wednesday, September 22, 1999 2:19 AM
> > To: INTERNET:[EMAIL PROTECTED]; Maurice Butler
> > Subject: Re: [DUG-DB]: Re: BDE
> >
> >
> >
> > The processing loop that is stalling our systems contains no SQL
> > or filters. Just a short series of inserts into large indexed tables.
> >
> > Steven
> >
>
>
> > 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 Wild
> Director
> Wild Software Ltd
> P O Box 33-216
> Christchurch, NZ
> Ph & Fax 64 3 377-0495
> _______________________
>
> Chreos Business Systems
> _______________________
> --------------------------------------------------------------------------
> -
> New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
