Using an 'index' that is able to differentiate on stringlength a typical string lookup can be improved. Using a 2.4M row string table, the (smallint) lookup consisting of string length is done in less than 200ms. The same 'fulltext' operation using %the string%, takes around 2500ms. Using a combination string_size >= length('string') and string ilike '%string%' the first lookup time can be reduced.
The (i)like operation has be striped from modifiers, due to the constant length we can assume that the string therefore always be longer.
This bug was previously known as tracker item 2902566 at http://sourceforge.net/support/tracker.php?aid=2902566
The original assignee of this bug does not have
an account here. Reassigning to the default assignee
for the component, email@example.com.
Previous assignee was firstname.lastname@example.org.