Myles
Sounds like a explanation and solution. Can you point me to the
reference to "private directories" that I need to change.
Steven
On 27 Sep 99, at 10:51, Myles Penlington wrote:
> 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
>
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
