Location of index files

pienokio

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

Anu D

Hi Martijn,

We have logged a support ticket for you and will check with our development team and get back to you!

Anu D

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?

puterdo_borato

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.

RichardL

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

Eddie D

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