Optimisation of the BDE with Oracle 8i

Article View: comp.lang.pascal.borland

Article #90

Back to comp.lang.pascal.borland Previous Next

#90

From: Steve
Date: Mon, 03 Dec 2001 16:42

16 lines
1996 bytes

Multi-tiers application in D5

We have a client application that has 6 different data modules which are 
connected to 6 different remote data modules.  These RDM are located on 
a computer and they connect, with the help of the BDE to an Oracle 8i 
database located on a different computer.

The application works well when the number of users is limited, but when 
the number becomes greater, the performance is greatly diminished.  We 
have increased the default values in the BDE configuration (INIT 
section) with some success, which is strange because according to the 
help files of the BDE, it would seem that when the values are too great, 
the benefits would disappear.

Would someone know what would be the optimum configuration of the BDE 
with Oracle?

Technical Details

Message-ID: <3C0BABBF.2010901@tourisme.gouv.qc.ca>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!cyclone.bc.net!sunqbc.risq.qc.ca!carnaval.risq.qc.ca.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6386,b2d7b5c50c3e59c1,start
X-Google-Attributes: gidf6386,public
X-Google-Thread: 111659,b2d7b5c50c3e59c1,start
X-Google-Attributes: gid111659,public
X-Google-Thread: 105ac8,b2d7b5c50c3e59c1,start
X-Google-Attributes: gid105ac8,public
X-Google-ArrivalTime: 2001-12-03 08:42:12 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!cyclone.bc.net!sunqbc.risq.qc.ca!carnaval.risq.qc.ca.POSTED!not-for-mail
Message-ID: <3C0BABBF.2010901@tourisme.gouv.qc.ca>
From: Steve <SPAMparis.steve@tourisme.gouv.qc.ca>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.3) Gecko/20010801
X-Accept-Language: fr-ca, en-us
MIME-Version: 1.0
Newsgroups: comp.lang.pascal.borland,alt.comp.borland-delphi,borland.public.delphi.database.multi-tier,comp.lang.pascal.borland
Subject: Optimisation of the BDE with Oracle 8i
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 17
Date: Mon, 03 Dec 2001 16:42:10 GMT
NNTP-Posting-Host: 207.35.108.2
X-Trace: carnaval.risq.qc.ca 1007397730 207.35.108.2 (Mon, 03 Dec 2001 11:42:10 EST)
NNTP-Posting-Date: Mon, 03 Dec 2001 11:42:10 EST