Re: Huge problem with COM+ performace?

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 - 08:37:48 CST