Hello,
we have an 8.5GB db with about 330K documents. This db used to contain no attachments but recently attachments have been added and the number of attachments in the db is increasing all the time. I’d estimate the average attachment size is about 70KB. They are .doc, .rtf and .pdf files and they need to be full-text indexed.
We have turned on the “Index Attachments” (Index attached files, Without using conversion filters). Now that we have tens of thousands attachments the FT index gets corrupted in few days after the index has been rebuilt. There is no error when searching but it just finds e.g. 100 docs only when the correct search result would be 1500 docs. This has been tested also with a simple FT search, just searching with one word.
Compact and fixup tasks have been run and I haven’t seen any full-text errors in the log. There are two rather new servers (a cluster) dedicated to this application so there should be no capacity problems. There are probably a few hundred users using the application at the same time.
Any ideas, experiences, suggestions or hints?
thank you,
Panu