My understanding is that proximity (within characters) searches do not take advantage of the metamorph indices.
[+] what about W/word, w/line, w/sent etc. Do these proximity search operators use the index at all?
[+] Is there anything that can be done to improve performance of within character searches? We have a large table with a blob field. the .blb file is about 60 GB. Proximity searches (w/chars) against this field often time out or take more than an hour. What would be a possible workaround for this issue?
Thanks in advance.
[+] what about W/word, w/line, w/sent etc. Do these proximity search operators use the index at all?
[+] Is there anything that can be done to improve performance of within character searches? We have a large table with a blob field. the .blb file is about 60 GB. Proximity searches (w/chars) against this field often time out or take more than an hour. What would be a possible workaround for this issue?
Thanks in advance.