Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why is Omni Tools slower after upgrading?

April 26, 2017Omni slower tools upgrading

0

Posted

Why is Omni Tools slower after upgrading?

1 Answer

0

Posted

When Great Plains SQL versions are upgraded, the standard upgrading code will drop ALL the Dexterity Auto Stored Procedures from the databases. It then recreates the these zDP stored procedures for its own tables, but leaves them missing for Third party products, including the Winthrop products. These stored procedures are used to gain a 300% performance improvement. Without them the code will still run, but be much slower. To fix, download and install the very latest builds and say “new install” to force the installation wizard to recreate the missing stored procedures for each company. Alternatively you can go to the About window and click the install button, then click the Advanced button to enable the advanced features of the classic installation window and then use the recreate buttons for both System and for each company.