Yes. In fact, we normally recommend it.You can achieve better performance connecting LinkFixer Advanced to your SQL Server database.


By default, LinkFixer Advanced uses SQLite, a file-system–based database that comes included with the LinkFixer Advanced software.


However, when processing large sets of files, you should install and configure Microsoft SQL Server or Microsoft SQL Express. We recommend that you only use the SQLite database that comes with LinkFixer Advanced for testing purposes or for processing data sets smaller than about 250 gigabytes.


When you use your SQL Server database, instead of the default SQLite database, LinkFixer Advanced will operate using multiple “threads” of the LinkFixer Advanced file-handling code. This will allow you to achieve faster processing speeds and get through your project faster.


Important: By default, Microsoft SQL will configure the database to grow “organically” as more space is needed. Because LinkFixer Advanced adds large numbers of entries very rapidly when scanning, the default SQL configuration can consume significant resources on the server, as SQL continuously attempts to increase the size of the database to keep up with new entries.


We recommend that you pre-allocate at least 500 megabytes to the database for each hundred thousand files that will be processed by LinkFixer Advanced, and configure SQL to grow the size of the database by 250-megabyte increments when necessary.


We also recommend that you provision your SQL Server machine with at least 16 gigabytes of memory and 4 cores. You should limit SQL Server’s use of memory to an amount that is 4 gigabytes less than the total available memory on the machine. This prevents SQL Server from using so much memory that it deprives Windows of memory it needs to operate efficiently.