Re: Huge problem with COM+ performace?

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 - 08:29:03 CST