December 30, 2009

gptip42day - Login to GP Faster

Suffering from long login times?  Here's a little trick that might help.  Delete all the records in the Menu Master table - SY07110.  When this table has accumulated too many records in it, it not only slows down login, it slows down logout also.  I just did this on my personal system and both the login and logout take a fraction of the time they did before.

You don't have to worry about deleting these records because GP recreates the table the next time you log in.


David Musgrave [MSFT] said...

If all add on products are correctly written, they should only add their menu entries to the syMenuMstr (SY07110) once. In this case the number of records in the table should be fixed and not increase over time.

If the table's records are increasing with each login, then there is a badly written piece of code which needs to be fixed.

Identify the Dictionary ID by looking at the latest records added (use order by Dex Row ID), look up that Dictionary ID in the Dynamics.set Launch file and contact the developer who created that dictionary.

I know that a couple of Microsoft add on products had this issue, but they have been fixed.

Note that this table is also used by a number of areas inside the application to read the menu structure, performance can be affected if the table is growing due to rogue code.


Frank Hamelly, MCP-GP, MCT, MVP said...

Thanks for the great tip David.