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
