I don't think you understand my point. Unlike SQLServer you can use server
side cursors without locking issues. Why allocate all that memory and get
records you may not need.
Jim
"David Kijanka" <kijanka_at_clarksecurity.com> wrote in message
news:3BDF55BB.25844A6D_at_clarksecurity.com...
> You don't have to do #2 at all: work with a disconnected recordset.
>
> Jim Kennedy wrote:
>
> > While you may have to do #2 in SQLServer you shouldn't have to in
Oracle.
> > Jim
> > "Saurabh Singhvi" <ssinghvi_at_mail.utexas.edu> wrote in message
> > news:#eol4DVYBHA.2144_at_tkmsftngp05...
> > > hi
> > > whats goin on
> > > this huge LAG may be due to open connections between your App and the
DB.
> > >
> > > 1) i would suggest that you look into Prepared Statements to increase
the
> > > efficiencey of your DB operations.
> > >
> > > 2) Also make sure that your DB connections are closed as soon as your
Data
> > > is retrieved.
> > > you can accomplish this by transferring the retrieved recordset into a
> > > static data structure and instantly closing the DB connection rather
than
> > > retrieveing the data, working with it using the same retrieved
recordset
> > and
> > > then closig the connection.
> > >
> > > 3) also you may want to look into DB replication and load balancing
> > > techniques.
> > >
> > > 4) finally the simplest method would be tominimize the number of
seperate
> > > calls to the DB and trying to aggregate the numerous calls into a few
or a
> > > single call if possible.
> > >
> > > hope these tips give you some direction.
> > >
> > > Saurabh Singhvi
> > > "Adam Boczek" <adam.boczek_at_NO_SPAM_gft-solutions.de> wrote in message
> > > news:1004438383.943613_at_tux2.ham.acs-gmbh.de...
> > > > I have huge problem :-|. I've written software which uses COM+ as
> > > midletier
> > > > and Oracle8i as datatier. All business components are VB dlls. All
> > clients
> > > > are VB exes. Everything seems to be ok (transactions etc.). But when
I
> > > start
> > > > long-lastig process (for example accounting for 300.000 clients) all
> > other
> > > > processes are locked (or very, very slow). I can NOT connect from
client
> > > to
> > > > my business components in COM+ (I receive no errors, only
information
> > that
> > > > process is pending) . Hardware is ok (2-Procesor server Compaq with
1,2
> > GB
> > > > RAM etc.), database parameters also (I can connect to database
without
> > > COM+
> > > > and run without problems any query), network 100MB/s and hi-end
> > switches.
> > > > I've tried different component configurations (all dll in one
package or
> > > in
> > > > groups) but without success.
> > > >
> > > > Any ideas?
> > > >
> > > > Win2k Srv SP2, Oracle8i (8.1.7.2), VB6 SP5, ADO 2.6 SP1, all clients
> > Win2k
> > > > Pro SP2.
> > > >
> > > > Greets,
> > > > Adam
> > > >
> > > > -------------------------------------------
> > > > Adam Boczek
> > > > IT Consultant
> > > > GFT Solutions GmbH
> > > > adam.boczek_at_gft-solutions.de
> > > > -------------------------------------------
> > > >
> > > >
> > > >
> > >
> > >
>
Received on Tue Oct 30 2001 - 19:52:53 CST
