Right, these are lots of small strings, not large texts. I don't know much about the index sizes and such, nor the hardware we use, except "try to keep your indexes cached." :-) And yes, that means we're careful not to overuse fti. It also helps to restrict searches so that you don't get large numbers of rows to search in the first place.
Right, these are lots of small strings, not large texts. I don't know much about the index sizes and such, nor the hardware we use, except "try to keep your indexes cached." :-) And yes, that means we're careful not to overuse fti. It also helps to restrict searches so that you don't get large numbers of rows to search in the first place.