Proximity and Linear table scan

gazim · Post by **gazim** » Wed Apr 19, 2006 5:12 pm

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.

gazim · Post by **gazim** » Thu Apr 20, 2006 7:35 pm

Forgot to add OS and Texis version information.

OS: Redhat Linux kernel 2.4.21-32.ELsmp
Texis: 04.04.1067366033(20031028)

Post by **John** » Thu Apr 20, 2006 9:03 pm

Newer versions can do within N words, and are also able to use the index to help with that as well as the within character form. The version you have will not be able to use the index for any proximity searches.