Quote:
Originally posted by tfjern
Yes, for future pdfs, fine, but what about the currently bloated index? It still shows 160 megabytes (even after compacting). Will I be stuck with this bloated index forever? Is there an option hidden somewhere where the index can be removed or reduced?
|
One option would be to create a new database and re-import the files.
Otherwise, if FTS is disabled (last option in compact/repair is unchecked):
1) Perform an advanced search of URL matches wildcard *.pdf
2) Select all search results.
3) Open the Item Keywords dialog (Item | Keywords) and Delete All auto-generated keywords.
4) Compact the database (Tools | Compact & Repair).
If FTS is enabled (last option in compact/repair is checked), use the
SQLite console to perform the following statements:
DELETE FROM ftsItem;
VACUUM;
This will remove all text indexing from all items in the database and compact.
Quote:
And what happens when pdfs, etc., are no longer indexed (and the index removed, if possible)? Does the database grind to a screeching halt? There doesn't seem to be any mention in the "help" file. Presumably searches will be slower, but how much slower? Be nice to know. Do I have to test things, first? Trial and error? Live and learn?
|
Nothing special happens. Searches may be faster, but you won't be able to search on text in imported PDF files.