"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."
My guess is the time is being spent blocking on N+1 as an example. This would explain the low load + performance problems On Mon, Jul 6, 2015 at 6:03 PM, Oskar Berggren <[email protected]> wrote: > > > 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. -- Studying for the Turing test -- 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.
