Reverting to previous QueryTerm.java that uses 'LIKE' for comparisons. This allows substring matching to work properly, but prevents the postgres index from being used. As a result, full table scans are done on the tables, causing a major performance hit. Need to determine how to eliminate the use of LIKE while maintaining the ability to do substring matching with wildcards or another mechanism.
Reverting to previous QueryTerm.java that uses 'LIKE' for comparisons. This
allows substring matching to work properly, but prevents the postgres index
from being used. As a result, full table scans are done on the tables, causing
a major performance hit. Need to determine how to eliminate the use of LIKE
while maintaining the ability to do substring matching with wildcards or
another mechanism.