Performance MRP-run Local client versus Native service

jeroenb

Dear all,

When running "the MRP-run" (>Manufacturing>Planning>planning worksheet>Functions>Calculate Regenerative Plan) i see a big difference in running as local client (via Database>Open) and connection via a Native service. Local the batch runs in about 1 hour and with the native service it runs more than 5 hours.
Specs:
technical objectversion: NAV4.0 sp1
Functional platformversion: NAV5.0sp1 and also NAV2009 R2 tried
Database size: 25000000 (kB)
Database size: 17731328 (kB)
DBMS-cache: 800000 (kB)
Commitcache: Yes

I have tried several different diskconfigurations (RAID6, RAID10, SSD) but in all the situations i see the same differences.
Who can help me with this case. I prefer a litlle change in configuration in the current Native-service, because we are on the way to migrate to a new version of NAV (NAV2013).
For the time being we need this tempory solution.

Kind regards,

Jeroen Bennink

kriki

The problem is that there is the network that slows down.

Give it a try to run the client directly on the server using 127.0.0.1 as the servername. This way the service connects to the service tier but avoids using the network. My experience is that it can enhance performance a lot.

jeroenb

Thanks Kriki, but i am not sure this would help, but give it a try.
I have tested to open the database via the service (on instance-name) on the server self with networkcable plugged in. The same result.
I'll try your suggestion by using the IP-number and portnumber (IP:portnumber). Let the result know.

If you have any other suggestion, they are welcome