Quote:
Originally Posted by chaley
...
One exception: I have seen slow searches when the comments columns contains huge amounts of text, the searches aren't prefixed, and the columns-to-search when prefixes aren't used isn't set (Preferences / Search / Limit the searched metadata. In one case the person was copying most of the book into the comments.
|
Yes, I thought of that after I posted. The OP mentioned a "mm_annotations" custom column, which I see is also long text. I suggest he excludes that column too.
If that solves the problem I'll move this convo to fresh a Lib Mgt sub-forum thread.
BR