mySQL SUBSTRING() vs POSITION() performance
Recently I needed to process a bunch of text to find about 1300 tokens(needles) amongst over a million text strings(haystack). One of the searches involved checking for token instances at the start of each text string. So I wrote a script that cycled through each needle and at the core … read more...