Hello. If you have a minute, I have a large db with one ms word attachment in each record. I found that ft search isn’t returning anything after a certain date. Looking closer, the difference is everything before the date is Huffman compression on $FILE and everything after is LZ1. So the FT Search sin’t working on LZ1 compressed files. Does anybody have any idea what I could do? Thank you so much for reading.
Subject: Perhaps there is a limitation on FT indexing being able to index multiple compression types
I have applications with LZ1 attachments that are FT-indexed, and searchable by their attachments. I would imagine that there is a limitation for FT indexing based on compression type. The FT index may be limited to indexing Huffman type or LZ1 type but not both simultaneously.
You may want to make a database copy of the application, and run compact -C -ZU to convert the Huffman compressed documents to LZ1, and then full-text index the application. If the FT index then is able to find documents before and after the date you found to be problematic, then do the same for the application with documents of a mixed compression type.