Solution:

Some picklists in Sage Pro ERP with Microsoft Visual FoxPro may be slower when a large amount data is present.

There is an option under the Settings tab for the datadrill to Optimize for Visual FoxPro database. Select this option and the picklist performance should improve. Before selecting this option, test the effects in a test environment first. Refer to the list below for more information:

• Many default picklists will already have this option set.
• This option should only be used in specific cases where large data is affecting the performance of the picklist.
• This option should only be used with single table datadrills.

© Copyright Sage Software