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 - 18:55:48 CST
