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
- My AI/LLM predictions for the next 1, 3 and 6 years, for Oxide and Friends - 10th January 2025
- Weeknotes: Starting 2025 a little slow - 4th January 2025
- I still don't think companies serve you ads based on spying through your microphone - 2nd January 2025