What is the most efficient way to lookup an object (e.g. a user) by only a string?
31st May 2012
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.
More recent articles
- The Summer of Johann: prompt injections as far as the eye can see - 15th August 2025
- Open weight LLMs exhibit inconsistent performance across providers - 15th August 2025
- LLM 0.27, the annotated release notes: GPT-5 and improved tool calling - 11th August 2025