8
« on: 2016-01-03 20:47:33 »
Hey everyone, first of all I want to thank each of you for your replies. You have been a great help! I agree with Gary, when you hit the 2GB limit, it can be a disaster. And that's my problem.
I am currently running some tests, playing with Thumbs to see what my best solution is. And from what I can tell, it's not about the number of files, but the total file size of the Thumbs database file. Theoretically, if I had 1 file that was 2GB in size, I will have used up my entire database. Let's hope that never happens!
First what I did was move all my files to 1 drive, scan the drive to create thumbs, and ran into problems. As expected, the database file reached the 2GB limit. Then what I did was move some of the files to the second drive. I went back to the first drive, removed any orphans, and did a Compact & Repaid of the database. I checked the 2 options for Cleanup dangling rows before compact, and Remove unused keywords from database. That decreased the size of the database file. I apologize I did not record the before and after file sizes.
I then moved to the second drive, created a second database, scanned, and successfully completed the task of creating thumbs for all my files on 2 drives.
So it appears I can create 2 separate database files, and keep an eye on my drives to keep certain I do not exceed the file size limitations.
Once again, I thank you all for your comments and suggestions, and thoughts. All of you have been a great help.
I would be interested if anyone has any additional comments to add to this thread.