Simon Willison’s Weblog

What is the most efficient way to lookup an object (e.g. a user) by only a string?

My answer to What is the most efficient way to lookup an object (e.g. a user) by only a string? on Quora

Yes—an index on a varchar column is exactly how you would implement this.

This is What is the most efficient way to lookup an object (e.g. a user) by only a string? by Simon Willison, posted on 31st May 2012.

Tagged , , ,

Next: Is there a single list of all tech conferences around the world?

Previous: Is there an API that returns metadata for a given URL?