Sorry Rachel but the best solution was a simple fix as mentioned by most people here - columns having the right types and indexes.

When I was still wet behind the ears I was doing what you are now proposing - but its overkill.