On Wed, Dec 1, 2010 at 3:50 PM, zuerrong <zuerrong / gmail.com> wrote:
> So I was thinking loading the whole data into memory, discarding
> mysql, and find a algorithm for doing it quickly.
> Any suggestion

try doing a soft binary search on the first column

best regards -botp