I am not that good with databases. So what is the down-side of adding all these indexes, will they be updated on every change of the database?
I saw that there is already one index: CREATE UNIQUE INDEX file_metadata_i1 ON file_metadata (filename, directory_path). I assumed this would speed-up the normal Books-view already?
Did you do a VACUUM before measuring the size of global.db?