TSession.PrivateDir
Specifies the directory in which to store temporary table processing files
generated by the Borland Database Engine (BDE) for database components
associated with a session.
property PrivateDir: string;
Description
Use PrivateDir to set the directory in which to store temporary table
processing files for all database connections, such as those generated by
the BDE to handle local SQL statements. Ordinarily this value is only set at
runtime, so that a user�s local hard disk is used to store temporary files.
Local storage of these files improves performance. If no value is specified
for PrivateDir, the BDE automatically stores temporary files in the
directory current at the time the BDE was initialized.
Note: For applications that run directly from a networked file server, the
application should set PrivateDir to a user�s local drive to improve
performance and to prevent temporary files from being created on the server
where they might conflict with temporary files created by other instances of
the application.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Steven Wild
Sent: Monday, 27 September 1999 16:11
To: Multiple recipients of list database
Subject: RE: [DUG-DB]: Re: BDE
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
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
