FYI. Locking usually isn't a problem as readers and writers don't block each
other. (writers can block other writers to the same row.)
Jim
"Ryan Cromwell" <ryan_at_digitallights.com> wrote in message
news:uuwV#8UYBHA.1748_at_tkmsftngp05...
> Adam,
>
> You may have already done this, but it will help many, including
> yourself, in attempting to solve your issue. Try to isolate the bogg in
your
> tiers. Where is the bulk of the logic. Start with that. If your logic
seems
> to be migrating its way over towards the com side, make sure that is
> necessary and if so, how many round trips are you running to your db
server.
> Excuse my Oracle8i ignorance, but check your locking. If you are able to
run
> queries simultaneously (especially with 2 proc.) that process the results
> and you are holding locks through out transactions you may have something.
> Sounds though, like your COM+ db tier ("I can connect to database without
> COM+ and run without problems any query") is your issue. How about the
> queries in question, are they running fine without the com+ layer. If so,
> I would jump through your code and see where you are running into the
> bottleneck. May be the provider you are using in your connection. These
> are of course suggested courses of action that I'm hoping you have already
> tried, so I'm hoping my comments are redundent otherwise you probably have
a
> bit of work for today :)
>
> Ryan Cromwell
>
> "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:54:37 CST
