Re: Huge problem with COM+ performace?

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:36:59 CST