Omni Tools slower after upgrading


Omni Tools slower after upgrading.


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 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.