SNOyowie

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...

Refsets for Exchange vs Interface

Everybody likes to talk about how necessary refsets are, but I’m not sure if the reason why is always known. One of the challenges facing implementers is how might they use what’s available and what else might they actually need?

So here’s what I think are two fundamental use cases … read more...