Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Huge problem with COM+ performace?

Re: Huge problem with COM+ performace?

From: Trevor Benedict R <*trevornews_at_yahoo.com*>
Date: Wed, 31 Oct 2001 09:43:24 +0800
Message-ID: <#eYjB2aYBHA.1424@tkmsftngp03>


Hi Adam,
Are U using any collection, because there's a overhead per object that you create(I think it's 16K). About 2 years back when I was patching a payroll system I came across a generic VB class that was being added into a collection. For the inital testing this was ok, but when we tried implementing it for about 1800 employees, we ran into the same problem. The process starts of very fast then slowly it became very slow. If you're using collections then it's only advisable.

Regards

Trevor Benedict R
Software Engineer
Mascot Malaysia Sdn Bhd

"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:43:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US