2015-07-06 13:13 GMT+01:00 Wesley Stocker <[email protected]>:

> The DB is hosted on the same machine as the export application.  With the
> current install, I am seeing 2600 results per hour be processed and minimal
> processor and memory load.  I was able to run a second instance of the
>


If the processor and memory load is minimal, what do you suppose the system
is doing the rest of the time? If the system has reached it's maximum
capacity, at least one of the basic resources (CPU, memory, disk IO,
network IO) should be near it's maximum capacity. Since you can run the
same application twice in parallel and get twice the throughput, it would
seem this is not a matter of resource exhaustion, and so I wouldn't expect
any significant gains from any typical algorithmic optimizations.

While there are have most definitely been optimizations applied in
NHibernate since v 1.2.1.4000, if your problem was with any of this I would
expect it to be visible as high CPU load.

If resource utilization is low and throughput is low but should be higher,
I would look for various types of delays, intentional or otherwise. Such as:

Is there any sort of network access involved that may be targeting a slow
server? Or trying to call a DNS resolver that doesn't respond (that's often
a 30s wait right there).

Is there any sort of explicit sleep going on in your program (intentional
or accidental)?

I suppose it could also stem from lock contention, if your program is doing
a lot of threads etc. - but I think you should see high CPU load if this
was the case.

When I speak about CPU load etc. I mean for the entire machine, not just
you program. At least the database process and any other process involved
in the task must be included when determining CPU load.

/Oskar

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.

Reply via email to