Slow 2017

Juhl

Hi all
I am upgrading a customer to 2017, and when creating a customer or opening the item or customer card, it is painfully slow.
This seems related to factboxes, and only with customer data, NOT cronus.
So there are many transactions.
CU1 didnt help!

Anyone made it so far and seen the same?

SQL profiler and CPU is showing a lot of activity! But i havent found the cause. Guessing error in flowfield or key.

Juhl

This does the trick

archer89

what were yur upgrade steps?
try to update first to nav 2016, then check performance. if ok, upgrade to nav 2017. check again.

Juhl

2009 > 2015 > 2017

But it is clean 2017 objects just added custom fields for dataupgrade.

I dont want to bring 2016 into this.
Removing factbox fixes it. But we need totalling of course.

archer89

are these factboxes from standard or custom? maybe to much flowfields.
also when calculating values by using setrange/setfilter always use a suitable key and apply it with setcurrentkey. using the wrong key can lower the performance.

Juhl

Standard all the Way.
I feel Cronus is slow too, but it has just a few transactions.

Wisa123

Check the following:
1.) Are there any keys missing in any of the Ledger tables ?
2.) Check whether there are any missing Views on SQL for those keys used by your FlowFields

davmac1

how much RAM do you have on your middle tier server? If you go with the 2GB in Microsoft's online statement, you will have terrible performance. I recommend 16GB to be safe for a small number of users. More for more users. The SQL Server should be configured properly with RAM, drives, and file placements.
I am guessing your problem is the RAM for the middle tier.
Publish your server specs and we can give you better advice.
Also, a recent blog recommended bumping up metadata provide cache from the default of 150 - try 5000 instead. It does not have a big cost in memory used but could provide a huge bump in performance.

Juhl

8GB with me alone as a user.

Juhl

Havent had time to tjek keys etc.
But it is standard objects !

Juhl

Hi Guys

Just got around to finding out what was going on.
And the problem is with Page 1345 Sales Price and Line Discounts, which is part of the Mini series. But this one is placed on the Customer Card in 2017 as a Part, but outside FactboxArea, so its not even visible and courses a huge calculation. See picture.

If anybody at MS is following, please take a look.

SQL Trace: (4-5 seconds)
exec sp_prepexec @p1 output,N'@0 int',N'SELECT "timestamp","Item No_","Sales Type","Sales Code","Starting Date","Currency Code","Variant Code","Unit of Measure Code","Minimum Quantity","Unit Price","Price Includes VAT","Allow Invoice Disc_","VAT Bus_ Posting Gr_ (Price)","Ending Date","Allow Line Disc_","Pre-Price" FROM "NAV-PREP".dbo."Ib Laursen$Sales Price" WITH(READUNCOMMITTED) WHERE ("Sales Type"=@0) ORDER BY "Item No_" ASC,"Sales Type" ASC,"Sales Code" ASC,"Starting Date" ASC,"Currency Code" ASC,"Variant Code" ASC,"Unit of Measure Code" ASC,"Minimum Quantity" ASC OPTION(OPTIMIZE FOR UNKNOWN, FAST 50)',@0=2
select @p1

Juhl

This does the trick

dtruppi

You can comment this for enhancing performances in onaftergetrecord, too:


//DaysPastDueDate := AgedAccReceivable.InvoicePaymentDaysAverage("No.");