Open Forum

Expand all | Collapse all

SET File Dictionary Locations

  • 1.  SET File Dictionary Locations

    SILVER CONTRIBUTOR
    Posted Nov 21, 2018 02:37 PM
    Hi, all. I'm going over our dynamics.set files and on all of them I see they point to the local directory (C Drive) for each dictionary but then points to a file share for the forms and reports. Is this required behavior or could I change the dictionary entries to point to a file share as well? If I am able to point it all to a file share, are there any risks other than the obvious if the share goes down, etc?

    I appreciate any help.

    ------------------------------
    Jon Godwin
    Database Administrator
    Pharmaca Integrative Pharmacy
    Boulder CO
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: SET File Dictionary Locations

    SILVER CONTRIBUTOR
    Posted Nov 22, 2018 12:52 AM
    Hey Jon;
    The Forms and Reports dictionaries are on a share because that way if you have to make a change to a form or report, you only have to make it once, then it's available to all installs.  Otherwise you would have to make  the change on each workstation.  The core dictionary is best if it's local, because then GP will run faster.  It's slow enough with the dictionary local.  If it had to go to a share, then it would slow it down considerably.  You could do it, but it will teach you patience.

    ------------------------------
    Merri Gorrell
    Business Applications Support
    Heska Corporation
    Loveland CO
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: SET File Dictionary Locations

    GPUG ALL STAR
    Posted Nov 22, 2018 12:53 AM
    @Jon Godwin

    Leave the application dictionaries local. There is no reason to share them and you will increase network traffic and cause performance loss if you did.

    I would go as far to say, don't share the custom forms and reports dictionary either. Please see my articles below for my reasoning and better alternatives.

    https://blogs.msdn.microsoft.com/developingfordynamicsgp/2008/08/20/automating-distribution-of-customizations-part-1/

    https://blogs.msdn.microsoft.com/developingfordynamicsgp/2008/08/26/automating-distribution-of-customizations-part-2/

    ​regards

    David

    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: SET File Dictionary Locations

    Posted Nov 22, 2018 12:59 AM
    Edited by Gavin Hundermark Nov 22, 2018 02:58 AM
    Hi Jon

    I can't recall if it was @David Musgrave or @Mariano Gomez that had a good article on file locations (I read it a few months ago, but can't find it now).

    The short answer is no, you don't want to do that.
    Some of the reasons being:
    - The IO on those files is going to slow GP down
    - Greater risk if there's a file corruption

    If I find the article I'll put the link up for you, otherwise one of the might jump in with the link.

    PS: even though we all do the shared reports/forms dictionaries, it's also not the best solution :)

    Regards
    ​​​
    Edit: I only saw @David Musgrave's response after I posted. Thanks David
    ------------------------------
    Gavin 'Yoda' Hundermark
    Technical Support Specialist
    African Global Operations (Pty) Ltd
    Krugersdorp South Africa
    ------------------------------

    Conference-GPUG_200x200


  • 5.  RE: SET File Dictionary Locations

    SILVER CONTRIBUTOR
    Posted Nov 22, 2018 11:57 AM
    Thanks everyone for the clarification. This helps clarify the set file for me.

    ------------------------------
    Jon Godwin
    Database Administrator
    Pharmaca Integrative Pharmacy
    Boulder CO
    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role