What are the challenges you face when working across database platforms? Take the survey

Location of index files

pienokiopienokio Posts: 2 New member
edited October 23, 2015 10:41AM in SQL Search
I'm using SQL search for a while.
Is it possible to change the location of the map where the index files are stored?
Now they're stored in my windows profile... so that's slowing down my logon proces ( it's about 3GB of indexed data )




  • Options
    Anu DAnu D Posts: 876 Silver 3
    Hi Martijn,

    We have logged a support ticket for you and will check with our development team and get back to you!
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    Anu DAnu D Posts: 876 Silver 3
    Hi Martijn,

    Thanks for your patience.

    At the moment there is no way to change the Index folder location and we have asked dev team to place this as a feature request.

    You can clear all the files and SQL Search will recreate them and that might improve the log on process.

    Does this help?
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    Hi support,
    Having SQL Search tool now distributed with Visual Studio 2017 this problem will affect much more users than before.
    Forever growing profile is a real problem in corporate PCs.
    Please make the index location configurable.
    Also please consider adding a big RED button to clear index files.

  • Options
    Hi @puterdo_borato

    Thanks for your post.

    You can always make feeature suggestions on our SQL Search Uservoice in my link below.


    Kind regards
    Customer Support
    Redgate Software
  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    edited February 19, 2018 4:35PM

    By default, all of Redgate's SQL tools create temporary files in the Windows Temp directories:
    C:\Users\<user name>\AppData\Local\Temp

    You can configure the RGTEMP environment variable, so that temp files our software generates are created in the RGTEMP location. For SQL Search, it will create the index files in this folder and not the default.

    If you wish to try out the RGTEMP environment variable, please follow the steps below.

    1. On another disk drive, create a folder called RGTEMP. For example,
    2. Right click 'MyComputer' or 'This PC' and select properties.
    3. Select 'Advanced system settings'.
    4. Click the 'Environment Variables' button.
    5. In the 'System variables' section, click the new button.
    6. For the 'Variable name' enter RGTEMP.
    7. For the 'Variable value' enter the path specified in Step 1, for example
    8. Click the 'OK' button total of 3 times, to close the dialog windows that opened.

    In some cases you may need to restart the machine for the change to take effect.

    Once the RGTEMP Environment Variable is in place, the Redgate tools will create their temporary files in the (using my example)
    folder, which may prevent any issues occurring from using the default Windows Temp directories.

    Hope the above helps.

    Many Thanks
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.