Location of index files

pienokiopienokio Posts: 2 New member
edited October 23, 2015 10:41AM in SQL Search
Hi,
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 )

Grtz

Martijn
Tagged:

Comments

  • 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: [email protected]
  • 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: [email protected]
  • 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.

    Thanks,
    Puterdo.
  • Hi @puterdo_borato

    Thanks for your post.

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

    https://redgate.uservoice.com/forums/101149-sql-search

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

    By default, all of Redgate's SQL tools create temporary files in the Windows Temp directories:
    C:\Windows\Temp
    or
    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,
    D:\RGTEMP
    
    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
    D:\RGTEMP
    
    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)
    D:\RGTEMP
    
    folder, which may prevent any issues occurring from using the default Windows Temp directories.

    Hope the above helps.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.