Problem
By default, FTK/Lab creates new cases in a single database using new schemas. This can cause slowness in processing and other functions once this database becomes very large.
Resolution
FTK/Lab Version 6.0.1 and above:
1) Open FTK.
2) Select Database menu and select "Put each case in its own DB".
FTK/Lab Version 5.6.x:
The script below will cause FTK/Lab to create a new database for each case. It should be used only on FTK/Lab version 5.6.
INSERT INTO ADG.ADG510.cmn_Settings (settingID, settingName, settingValue) values (0, 'CaseDatabaseSettings', '<CaseDatabaseSettings><MultiDB>true</MultiDB></CaseDatabaseSettings>')
Cause
The option to create a new database for each new case was added in version 6.0.1 of FTK/Lab. However, that setting is not the default (as of FTK/Lab version 6.2.1).
Summation Pro and AD eDiscovery already include this functionality.
Great Tip thank you.
I try to not create cases in LAB for consistency reasons but am sometimes forced to because of case requirements. This is a great way of keeping the ADG db small and lab cases in line with Summation cases.