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
- Trying out llama.cpp's new vision support - 10th May 2025
- Saying "hi" to Microsoft's Phi-4-reasoning - 6th May 2025
- Feed a video to a vision LLM as a sequence of JPEG frames on the CLI (also LLM 0.25) - 5th May 2025